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

88 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
flattish145526(None) 
fattish1359261f_attish
flatfish1744931flatfish
brattish1346972brattish
cattish12410722_cattish
flattest1138712flattest
flatting123511252flatting
flatwash1742422flatwash
flatwise1443972flatwise
flautist1186802flautist
latish92416172_la_tish
rattish10510822_rattish
sluttish1145442sluttish
abattis9297823abattis_
batfish1558683_batfish
blackish1976713blackish
blandish1497003blandish
blatting114111653blatting
catfish1559023_catfish
clannish1345263clannish
clayish1547943cla_yish
faddish15359003f_addish
faintish1446193faintish
fairish1338993f_airish
fallfish1744463fallfish
famish14311843f_a_mish
fattest102913063f_attest
fattier103513463f_attier
fatties103018203f_atties
fattiest113514313f_attiest
fattily13379463f_attily
fatting113818703f_atting
fetish12310373f__etish
fiftyish2042553fiftyish
flash115716213fla___sh
flatfishes1943993flatfishes
flatline11298923flatline
flatling123410013flatling
flatness1138153flatness
flats86429743fla_t_s_
flatted114012943flatt_ed
flatten10429653flatt_en
flattens11357483flattens
flatter103815963flatt_er
flatters113814203flatters
flattery14338293flattery
flattop1244403flatt_op
flattops1344553flattops
flatus94310783fla_tus_
flautas1036153flautas_
flautists1253683flautists
flemish1536373fl_emish
flitting123010883flitting
flourish1446753flourish
fluish1239333fl__uish
flutist102910783fl_utist
fortyish1744843fortyish
glottis837173glottis_
goatfish1544293goatfish
goatish1139563goa_tish
hottish13117903_hottish
laddish12299723_laddish
ladyish14287823_ladyish
largish1138603_largish
larkish1439083_larkish
lathis95516173_lathis_
lattes65324203_lattes_
lattice938433_lattice
lattin64316223_latti_n
lattins74115483_lattins
lavish124112983_la_vish
lazyish22265853_lazyish
leftish13197253_leftish
littlish1145043_littlish
loutish1039963_loutish
pettish1238283_pettish
planish12412053pla_nish
platting114813033platting
platyfish2042683platyfish
ratfish1338773_ratfish
ruttish1048303_ruttish
saltish10312163_saltish
skittish1544503skittish
slatting94014233slatting
slavish1338233sla_vish
sottish10129443_sottish
tartish101512633_tartish
wettish1335963_wettish

Search took 9 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.436409841.7
2DLD Change Limit146162888.00018270.3
3Display Results88880.0332666.7
 (SQL Overall)178691888.46921099.4
 
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.