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

233 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
dollish1161009(None) 
doltish11118731doltish
dullish1148741dullish
bullish12511192bullish
coldish1399302coldish
coltish121310932coltish
coolish12312522coolish
delish105215612d_elish
dogfish15226762dogfish
doggish13237532doggish
dollied93811142dollied
dollies83620982dollies
dolling93817372dolling
dollishly1643682dollishly
dolls66126922doll_s_
donnish11187632donnish
dovish1338102do_vish
folkish1736562folkish
follis93113902follis_
foolish1339612foolish
hellish13310722hellish
oldish10169312_oldish
owlish1238702_owlish
polish114916722po_lish
pollist9816602pollist
tallish103313582tallish
wolfish1636932wolfish
abolish12311503abolish
baldish1339503baldish
billfish1645033billfish
bluish1159243_bluish
boarish123911913boarish
boggish14238653boggish
bolling103820883bolling
bollix1538053bolli_x
bolls75531313boll_s_
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233bo_yish
carlish12312773carlish
cellist9314423cellist
ceorlish1345383ceorlish
coalfish1635493coalfish
cockish1838503cockish
codfish1637163codfish
collide103214793collide
collie83621993colli_e
collied103316673collied
collier93618153collier
collies94326583collies
collins93419833collins
coulis84018763coulis_
cowfish1836433cowfish
coyish143710393co_yish
cullis84115993cullis_
cultish12139113cultish
dalles74222063dalles_
dallied93713613dallied
dallier84215373dallier
dallies84023193dallies
dampish1567663dampish
danish101513793d_anish
darkish1537943darkish
deafish1438533deafish
dealfish1545503dealfish
delis64928543d_elis_
delist74625053d_elist
dellies83622213dellies
dells66630943dell_s_
demolish1447833demolish
depolish1446943depolish
dervish1436983dervish
devilish1546373devilish
dialist8517763dialist
diallist949553diallist
dillies84122163dillies
dills65530973dill_s_
dish86328333d___ish
doblas93812293doblas_
dodoism1135893dodoism
doglike13207453doglike
doilies84017363doilies
dolci84912603dolci__
doles67843753do_les_
doling84923133do_ling
doll56632493doll___
dollar74110983doll_ar
dollars83311023dollars
dolled83518073doll_ed
dollop9259363doll_op
dollops10287963dollops
dolly96125203doll__y
dollying13407413dollying
dolmas95213043dolmas_
dolors75115313dolors_
dols56943053do_l_s_
doltishly1643383doltishly
dolts65626313do_lts_
doolie73916833dooli_e
doolies83920713doolies
doulas75114993doulas_
dowdyish1952833dowdyish
doylies114512573doylies
drollest937353drollest
drolling103510763drolling
drolls75312393droll_s_
dronish1138913dronish
dryish1336323d_ryish
dualism1049163dualism
dualist8614053dualist
dudish1148313d_udish
duelist8511413duelist
duellist986333duellist
dullest8312633dullest
dulling93418273dulling
dullishly1643383dullishly
dulls64523743dull_s_
dumpish15116113dumpish
duncish1335793duncish
duskish1535183duskish
elfish1267963_elfish
elvish1277563_elvish
english1137953english
eolith93013903eo_lith
fallfish1744463fallfish
fluish1239333_fluish
fogyish1735363fogyish
folles93820473folles_
follies103618943follies
foolfish1744393foolfish
foppish1735103foppish
foxfish2354483foxfish
ghoulish1543543ghoulish
girlish1137193girlish
goatish1139563goatish
goldfish1644203goldfish
golosh1036463go_losh
goodish1237963goodish
goulash1164273goulash
goyish13379013go_yish
hogfish17257023hogfish
hoggish15247593hoggish
holism113713753ho_lism
holist94723213ho_list
hollas94616903hollas_
hollies103420813hollies
hollos95320633hollos_
hottish13117903hottish
idolise839293ido_lise
idolism1037273ido_lism
idyllist1243963idyllist
jollied15349273jollied
jollier142911003jollier
jollies143516273jollies
jolliest152910363jolliest
jollify2044263jollify
jollily1745773jollily
jollity1746143jollity
loggish12258723loggish
lollies73116923lollies
lolling83415773lolling
lolls512121733loll_s_
longish11229093longish
loudish1137983loudish
loutish1039963loutish
lowish12310533lo_wish
mobbish1635923mobbish
modish123813543mo_dish
mollah11319453moll_ah
mollahs12328283mollahs
mollie83517103molli_e
mollies93420233mollies
mollify1555503mollify
molls75129783moll_s_
mollusc11103093mollusc
mollusk13103123mollusk
monish114217593mo_nish
monkish1638243monkish
moonish123311043moonish
moorish123311783moorish
mopish134311593mo_pish
mulish11311903_mulish
noirish1037883noirish
nourish1039703nourish
oafish121311723_oafish
odalisk1265373odalisk
oddish11107653_oddish
offish15137273_offish
ogrish1039263_ogrish
ollas54218283_ollas_
oolith93813243_oolith
palish114718273_palish
poleis86018353poleis_
polis74731163po_lis_
polling102920383polling
pollists10910823pollists
polls74627723poll_s_
poloist91016323poloist
poorish123712303poorish
popish133812113po_pish
publish1447913publish
relish93916953_relish
roguish1156833roguish
rollick1335613rollick
rolling83620413rolling
rolls55326233roll_s_
rompish1436693rompish
saltish10312163saltish
selfish1388513selfish
slowish1337633slowish
smallish1346573smallish
softish13127813softish
soloist7915893soloist
sottish10129443sottish
sourish10310693sourish
stylish13197443stylish
tallis63319963tallis_
tallith102913063tallith
toadish1139063toadish
tolling83418563tolling
tolls54728433toll_s_
tonish93415903to_nish
tonnish10149093tonnish
townish13167933townish
toyish122911123to_yish
voguish1465203voguish
wildish1446853wildish
woggish15276673woggish
wolffish2043333wolffish
wormish1537163wormish
yokelish1843983yokelish

Search took 7 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.406440125.6
2DLD Change Limit1340272335.83022989.2
3Display Results2332330.0932505.4
 (SQL Overall)1786912336.32928233.7
 
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.