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

228 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
foolish133961(None) 
coolish12312521coolish
foolfish1744391foolfish
abolish12311502abolish
boobish14338942boobish
bookish163610022bookish
boorish123712592boorish
dollish11610092dollish
fogyish1735362fogyish
folkish1736562folkish
follis93113902follis_
fooling113117372fooling
foolisher1544222foolisher
foolishly1843762foolishly
fools86824202fool_s_
foppish1735102foppish
foxfish2354482foxfish
goodish1237962goodish
moonish123311042moonish
moorish123311782moorish
oolith93813242_oolith
owlish1238702_owlish
polish114916722_polish
poorish123712302poorish
aiolis6316843aiolis_
boarish123911913boarish
boggish14238653boggish
boxfish2285543boxfish
boyish142911233_boyish
bullish12511193bullish
carlish12312773carlish
ceorlish1345383ceorlish
coalfish1635493coalfish
cockish1838503cockish
codfish1637163codfish
coldish1399303coldish
coltish121310933coltish
coolest9318643coolest
coolie83821603cooli_e
coolies93824963coolies
cooling103422573cooling
cools75632633cool_s_
coolth1139513cool_th
coolths1236013coolths
coulis84018763coulis_
cowfish1836433cowfish
coyish143710393_coyish
cronish12310863cronish
delish105215613_delish
demolish1447833demolish
depolish1446943depolish
dogfish15226763dogfish
doggish13237533doggish
doltish11118733doltish
donnish11187633donnish
doolie73916833dooli_e
doolies83920713doolies
dovish1338103_dovish
dronish1138913dronish
dullish1148743dullish
english1137953english
eolith93013903_eolith
faddish15359003faddish
fairish1338993fairish
fallfish1744463fallfish
famish14311843f_amish
fattish1359263fattish
feeblish1644163feeblish
fetish12310373f_etish
finfish16268193finfish
finish124613413f_inish
fish106926273f___ish
flash115716213f__lash
flemish1536373flemish
flesh115013743f__lesh
florist10314243florist
flourish1446753flourish
fluish1239333f_luish
flush115116073f__lush
foaling113515843foaling
foals85721693foal_s_
focalise131210373focalise
fogeyish1843843fogeyish
fogless1138193fogless
fogyism1643943fogyism
foiling113317653foiling
foils85025813foil_s_
foist85730973f_o_ist
folds95221693f_olds_
folia83618933f_oli_a
foliar93210973f_oliar
folic105319323f_oli_c
folio83820883f_oli_o
folios93915463f_olios
foliose10378013f_oliose
folium11310453f_olium
folks126017123f_olks_
folksy16484983f_olksy
folles93820473folles_
follies103618943follies
foodie104413843foodi_e
foodies113416753foodies
foodless12338383foodless
foods95924163foo_ds_
fool75330593fool___
fooled104317823fool_ed
foolery1336693foolery
foolfishes1943763foolfishes
foolishest1643853foolishest
footie94718143footi_e
footier104115113footier
footies103721543footies
footiest113514913footiest
footing115017593footing
footles103715713footles_
footless113710803footless
footlight16255273footlight
footlike1537253footlike
footling12239923footling
foots85528283foo_ts_
footsie1047653footsie
footsy12587933foo_tsy
foozles19329543foozles_
foozling21275723foozling
fortis95418613fortis_
fortyish1744843fortyish
foulest10313313foulest
fouling113315373fouling
fouls87221433foul_s_
fowling143713113fowling
fowls115518893fowl_s_
foxlike21226223foxlike
frogfish1843943frogfish
frolic1149203froli_c
frolics1236833frolics
frosh115713403fro__sh
furbish1536443furbish
furnish1337383furnish
ghoulish1543543ghoulish
girlish1137193girlish
gnomish1345563gnomish
goatish1139563goatish
golosh1036463_golosh
goulash1164273goulash
goyish13379013_goyish
hellish13310723hellish
hogfish17257023hogfish
hoggish15247593hoggish
holism113713753_holism
holist94723213_holist
hoolie93217783hooli_e
hottish13117903hottish
idolise839293idolise
idolism1037273idolism
loggish12258733loggish
longish11229093longish
lookism1335913lookism
lookist1139563lookist
loudish1137983loudish
loutish1039963loutish
lowish12310533_lowish
mobbish1635923mobbish
modish123813543_modish
monish114217593_monish
monkish1638243monkish
monolith1349673monolith
moolah11409193mool_ah
moolahs12347383moolahs
moolas83615593moolas_
mools76027173mool_s_
moonfish1675333moonfish
mopish134311593_mopish
mulish11311903_mulish
neolith1068783neolith
noirish1037883noirish
nourish1039703nourish
oafish121311723_oafish
oddish11107653_oddish
offish15137273_offish
ogrish1039263_ogrish
oldish10169313_oldish
oolite63319603_oolite
ooliths10268323_ooliths
otolith10108283otolith
palish114718273_palish
polis74731163_polis_
pollist9816603pollist
poloist91016323poloist
pooling103219093pooling
pools74427703pool_s_
pooris83916843pooris_
popish133812113_popish
publish1447913publish
relish93916953_relish
repolish1347933repolish
roguish1156833roguish
rompish1436693rompish
slowish1337633slowish
softish13127813softish
soloist7915893soloist
sottish10129443sottish
sourish10310693sourish
spookish1744643spookish
stonish10410653stonish
stylish13197443stylish
tallish103313583tallish
toadish1139063toadish
tonish93415903_tonish
tonnish10149093tonnish
tooling82918313tooling
tools55325243tool_s_
townish13167933townish
toyish122911123_toyish
urolith1048783urolith
violist10312143violist
voguish1465203voguish
wholism1535883wholism
whorish1636603whorish
woggish15276673woggish
wolfish1636933wolfish
woolie93514483wooli_e
woolier103612353woolier
woolies104117363woolies
wooliest113011643wooliest
wools84421463wool_s_
woosh113710733woo__sh
wormish1537163wormish
yokelish1843983yokelish

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.423422437.4
2DLD Change Limit1340272286.87619492.0
3Display Results2282280.0763000.0
 (SQL Overall)1786912287.37524229.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.