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 “doltish” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

206 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
doltish1111873(None) 
coltish121310931coltish
dollish11610091dollish
coldish1399302coldish
cultish12139112cultish
delish105215612del_ish
dogfish15226762dogfish
doggish13237532doggish
doltishly1643382doltishly
dolts65626312dolt_s_
donnish11187632donnish
dovish1338102do_vish
dullish1148742dullish
folkish1736562folkish
goatish1139562goatish
hottish13117902hottish
loutish1039962loutish
oldish10169312_oldish
polish114916722pol_ish
saltish10312162saltish
softish13127812softish
sottish10129442sottish
wolfish1636932wolfish
abolish12311503abol_ish
baldish1339503baldish
bluish1159243_bluish
boarish123911913boarish
boggish14238653boggish
bolting104416763bolting
bolts76232113bolt_s_
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233bo_yish
brutish1237703brutish
bullish12511193bullish
cattish12410723cattish
coalfish1635493coalfish
coatis85122603coatis_
cockish1838503cockish
codfish1637163codfish
colitis92617353colitis_
coltishly1744213coltishly
colts76633293colt_s_
coolish12312523coolish
cowfish1836433cowfish
coyish143710393co_yish
cultism11158003cultism
cultist91412713cultist
dampish1567663dampish
danish101513793d_anish
darkish1537943darkish
deafish1438533deafish
dealfish1545503dealfish
delis64928543del_is_
delist74625053del_ist
deltas74414823deltas_
deltic9312503delti_c
delts65731793delt_s_
demolish1447833demol_ish
dentist8316743dentist
depolish1446943depol_ish
dervish1436983dervish
dhootis1135683dhootis_
dhotis1038973dhotis_
dhutis1035943dhutis_
dish86328333d___ish
distich13312173distich
doating93816863doating
doats65224883doat_s_
dodoism1135893dodoism
doeth9411983doet__h
doits66223673doit_s_
dolci84912603dolci__
doles67843753dol_es_
doling84923133dol_ing
dollied93811143dollied
dollies83620983dollies
dolling93817373dolling
dollishly1643683dollishly
dolls66126923dol_ls_
dolmas95213043dolmas_
dolors75115313dolors_
dols56943053dol__s_
dolt56649423dolt___
dotes65836693do_tes_
doth86225713do_t__h
dotier73917033do_tier
dotiest83717453do_tiest
doting84821913do_ting
dots55647663do_t_s_
dottier83910923dottier
dottiest92611393dottiest
dottily1147283dottily
dotting93314483dotting
dowdyish1952833dowdyish
dronish1138913dronish
dryish1336323d_ryish
dudish1148313d_udish
dumpish15116113dumpish
duncish1335793duncish
duskish1535183duskish
elfish1267963_elfish
elvish1277563_elvish
eolith93013903eol_ith
eoliths10318573eoliths
fattish1359263fattish
fetish12310373_fetish
fluish1239333_fluish
fogyish1735363fogyish
follis93113903follis_
foolfish1744393foolfish
foolish1339613foolish
foppish1735103foppish
fortis95418613fortis_
fortyish1744843fortyish
foxfish2354483foxfish
goatfish1544293goatfish
goldfish1644203goldfish
golosh1036463gol_osh
goodish1237963goodish
goyish13379013go_yish
hellish13310723hellish
hogfish17257023hogfish
hoggish15247593hoggish
holism113713753hol_ism
holist94723213hol_ist
holts85627913holt_s_
idolise839293idol_ise
idolism1037273idol_ism
joltier14318493joltier
joltiest15249403joltiest
joltily1746323joltily
jolting153410913jolting
jolts125018883jolt_s_
latish92416173_latish
leftish13197253leftish
loggish12258733loggish
longish11229093longish
loudish1137983loudish
lowish12310533lo_wish
mobbish1635923mobbish
modish123813543mo_dish
molting103517173molting
molts76032093molt_s_
monish114217593mo_nish
monkish1638243monkish
moonish123311043moonish
moorish123311783moorish
mopish134311593mo_pish
mortise9713533mortise
mulish11311903mul_ish
noirish1037883noirish
nourish1039703nourish
oafish121311723_oafish
oddish11107653_oddish
offish15137273_offish
ogrish1039263_ogrish
oolith93813243ool_ith
ooliths10268323ooliths
outfish132210573_outfish
outwish13289853_outwish
owlish1238703_owlish
palish114718273pal_ish
pettish1238283pettish
poetise9314043poetise
poleis86018353poleis_
polis74731163pol_is_
pollist9816603pollist
poloist91016323poloist
poorish123712303poorish
popish133812113po_pish
potash1138273po_tash
rattish10510823rattish
relish93916953rel_ish
roguish1156833roguish
rompish1436693rompish
rotis56327063ro_tis_
runtish1048693runtish
ruttish1048303ruttish
selfish1388513selfish
shortish1437423shortish
slowish1337633slowish
snoutish1145783snoutish
soloist7915893soloist
sourish10310693sourish
stoutish1145903stoutish
tallish103313583tallish
tartish101512633tartish
toadish1139063toadish
tonish93415903to_nish
tonnish10149093tonnish
townish13167933townish
toyish122911123to_yish
voguish1465203voguish
voltaism1344813voltaism
voltes94915583voltes_
volti84915963volti__
volts85421293volt_s_
wettish1335963wettish
whitish1635973whitish
wildish1446853wildish
woggish15276673woggish
wolffish2043333wolffish
wormish1537163wormish

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 Filter1786911340270.436409841.7
2DLD Change Limit1340272067.14318763.4
3Display Results2062060.0762710.5
 (SQL Overall)1786912067.65523343.0
 
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.