Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “piciform” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
piciform176500(None) 
piliform1555481piliform
piriform1555761piriform
pisciform1843261pisciform
pisiform1564971pisiform
aciform1446022_aciform
arciform1544802arciform
disciform1744132disciform
filiform1644782filiform
pediform1645192pediform
pisiforms1643502pisiforms
pyriform1844412pyriform
unciform1544662unciform
aciniform1642803aciniform
aeriform1346103aeriform
aliform1247043_aliform
auriform1345193auriform
bacciform2052543bacciform
biform1368133__biform
cirriform1643523cirriform
coliform1545573coliform
cruciform1843173cruciform
cubiform1744023cubiform
cuniform1555033cuniform
deiform1336703_deiform
disinform1544123disinform
ensiform1344363ensiform
falciform1943093falciform
fusiform1643993fusiform
gasiform1444313gasiform
gruiform14103383gruiform
inform11310153_i_nform
isoform1244963_isoform
janiform2044733janiform
lanciform1643593lanciform
libriform1642843libriform
lyriform1643553lyriform
microform1846503microform
misform1437513mi_sform
misinform1643783misinform
napiform1543773napiform
omniform1544013omniform
oviform1544823_oviform
pacifism1746383pacifism
paraform1546943paraform
perform1439293p_erform
picador1245923picador_
picadors1345853picadors
picloram1445913pic_loram
piedfort1444883piedfort
piefort1249543pi_efort
pinafore1344513pinafore
pinworm1467183pi_nworm
piscivore1652363piscivore
pitchfork2352553pitchfork
planform1544763planform
platform1544593platform
plexiform2342323plexiform
postform1556223postform
preform1439623p_reform
preinform1644763preinform
ramiform1544713ramiform
reniform1346243reniform
retiform1345873retiform
rotiform1344673rotiform
setiform1345013setiform
stipiform1642363stipiform
triform1237863_triform
tubiform1543743tubiform
unciforms1643353unciforms
uniform1247063_uniform
ursiform1343763ursiform
variform1645013variform
vasiform1644243vasiform
villiform1743353villiform
vitriform1743333vitriform

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.423422437.4
2DLD Change Limit146162766.57622226.6
3Display Results76760.0332303.0
 (SQL Overall)178691767.03225411.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.