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 “flatfish” 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.

91 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
flatfish174493(None) 
flattish1455261flattish
batfish1558682_batfish
catfish1559022_catfish
fallfish1744462fallfish
fattish1359262f_attish
flatfishes1944002flatfishes
flatwash1742422flatwash
flatwise1443972flatwise
goatfish1544292goatfish
latish92416172_lat_ish
platyfish2042682platyfish
ratfish1338772_ratfish
baitfish1645483baitfish
blackfish2343833blackfish
blackish1976713blackish
blandish1497003blandish
blowfish1944703blowfish
bluefish1645143bluefish
boarfish1635753boarfish
brattish1346973brattish
cattish12410723_cattish
clannish1345263clannish
clayish1547943cla_yish
coalfish1635493coalfish
crawfish1944233crawfish
crayfish1944253crayfish
deafish1438533dea_fish
dealfish1545503dealfish
draffish1844553draffish
dwarfish1843783dwarfish
elfish1267963el__fish
faddish15359003f_addish
fairish1338993f_airish
famish14311843f_a_mish
fetish12310373f_et_ish
fiftyish2042553fiftyish
filefish1745593filefish
finfish16268193f_infish
flash115716213fla___sh
flatfeet1446213flatfeet
flatfoot1445293flatfoot
flatline11298923flatline
flatling123410013flatling
flatness1138153flatness
flats86429743flat__s_
flattest1138713flattest
flatting123511253flatting
flatus94310783flat_us_
flautist1186803flautist
flemish1536373fl_emish
flourish1446753flourish
fluish1239333fl__uish
flutist102910783flut_ist
foolfish1744393foolfish
fortyish1744843fortyish
foxfish2354483f_oxfish
frogfish1843943frogfish
frostfish1842623frostfish
garfish14179203_garfish
goatish1139563goat_ish
grayfish1844483grayfish
hagfish17227613_hagfish
headfish1845443headfish
laddish12299723_laddish
ladyfish1843803_ladyfish
ladyish14287823_ladyish
largish1138603_largish
larkish1439083_larkish
lathis95516173_lathis_
lavish124112983_la_vish
lazyish22265853_lazyish
leftish13197253_leftish
lutfisk1443583_lutfisk
oafish121311723_oa_fish
oarfish13158613_oarfish
outfish132210573_outfish
panfish15229973_panfish
pilotfish1742603pilotfish
planish12412053pla_nish
raffish1658843_raffish
rattish10510823_rattish
saltish10312163salt_ish
sawfish1637683_sawfish
sheatfish1843253sheatfish
slavish1338233sla_vish
sluttish1145443sluttish
starfish1438083starfish
toadfish1544903toadfish
waifish1637703_waifish
weakfish2143523weakfish

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.483369960.7
2DLD Change Limit146162917.15620425.1
3Display Results91910.0332757.6
 (SQL Overall)178691917.67223291.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.