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

276 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
stoolies831108(None) 
stoolie739721stoolie_
coolies93824962_coolies
dhoolies1246962dhoolies
doolies83920712_doolies
shooflies1544142shooflies
spoonies101911752spoonies
steelies8312552steelies
stogies8413692st_ogies
stoles63927672st_ol_es
stooges83611482stoo_ges
stooled84313892stool_ed
stooling93113132stooling
stools65117022stool__s
stories7324272st_ories
toonies73719882_toonies
woolies104117362_woolies
astonies8815113ast_onies
atomies93918363at_omies
atonies75320953at_onies
atopies92816433at_opies
bloodies11310163bloodies
boobies113718203_boobies
boodies103721443_boodies
boogies103719013_boogies
bookies133819403_bookies
boonies93422483_boonies
booties94124613_booties
botflies1336733botflies
brollies1039533brollies
brookies1459143brookies
colies84837053__colies
collies94326583_collies
cookies133719273_cookies
coolie83821603_coolie_
cooties93725733_cooties
dhooties1237643dhooties
doilies84017363_doilies
dollies83620983_dollies
doobies103915673_doobies
doodies94218773_doodies
doolees83711613_doolees
doolie73916833_doolie_
doozies173812723_doozies
doylies114512573_doylies
droolier936073droolier
drooliest1036343drooliest
duopolies1244323duopolies
embolies1239153embolies
ethoxies1845703ethoxies
etoiles7411293etoil_es
floosies113210233floosies
floozies20326953floozies
follies103618943_follies
foodies113416753_foodies
footies103721543_footies
ghoulies1235393ghoulies
goalies8316023_goalies
goodies93516993_goodies
googlies1086763googlies
goonies83618333_goonies
holies94630033__holies
hollies103420813_hollies
hoodies113419833_hoodies
hookies144017443_hookies
hoolie93217783_hoolie_
isotopies11207353isotopies
jollies143516273_jollies
lollies73116923_lollies
loobies93814103_loobies
looies65025833_loo_ies
loonies73919543_loonies
molies84429513__molies
mollies93420233_mollies
noogies82814583_noogies
nookies113414963_nookies
oolites72817843__oolites
ostioles839273ostiol_es
ostomies10310583ost_omies
otologies10311403otologies
patooties1147183patooties
polies84034583__polies
roofies103014413_roofies
rookies113917103_rookies
roomies93017243_roomies
sallies73227813s_allies
savories11311273savories
sawflies1444743sawflies
saxonies1537913saxonies
scolices1238733s_colices
scooches15188413scooches
scotties1039753scotties
shoalier1137073shoalier
shoaliest1238513shoaliest
shoddies1336053shoddies
shooled115212663shool_ed
shooling123012563shooling
shools94919013shool__s
shorties11414583shorties
sicklies14710013sicklies
sillies73425083s_illies
simonies10311113simonies
sitologies1148703sitologies
smooches15217263smooches
smooshes13206863smooshes
smoothes13218543smoothes
smoothies1456133smoothies
snooled84513943snool_ed
snooling93013473snooling
snools65715883snool__s
snoopier10177273snoopier
snoopiest11157073snoopiest
snootier8278383snootier
snootiest9178753snootiest
snoozes16289783snoo_zes
snoozier17185193snoozier
snooziest18175393snooziest
snoozles17335563snoozles
socles8418453s_ocl_es
soddies92312853s_oddies
sodomies11128553sodomies
softies103414613s_ofties
soles55547923s__ol_es
solids74116403s__olids
solves95018223s__olves
sonnies7315223s_onnies
soothes103917113s_oothes
sootier73916613s_ootier
sootiest84016753s_ootiest
sophies12314623s_ophies
sorties74126403s_orties
sotols63714473sotol__s
spookier14175493spookier
spookiest15156403spookiest
spooled104613523spool_ed
spooler93711383spool_er
spoolers10349363spoolers
spooling113212563spooling
spoolings12245393spoolings
spools85115913spool__s
spoonier10167653spoonier
spooniest11178143spooniest
stabiles10311403stabiles
stables93219073stabl_es
staggies101210323staggies
stales65538293st_al_es
staples93617213stapl_es
steadies9311123steadies
steelie7310213steelie_
steelier839193steelier
steeliest939643steeliest
steles63725663st_el_es
stellites938123stellites
stenokies1345313stenokies
stickies142211973stickies
sties55132983st___ies
stiffies14258383stiffies
stifles103013393stifl_es
stiles64328773st_il_es
stillier868823stillier
stilliest939223stilliest
stimies9316563st_imies
stithies1139233stithies
stockier14217253stockier
stockiest15207753stockiest
stodges9309083st_odges
stodgier1034223stodgier
stodgiest1135653stodgiest
stogie7311323st_ogie_
stoics8311113st_o_ics
stokes104821793st_o_kes
stole54928813st_ol_e_
stoled74521593st_ol_ed
stolen64315063st_ol_en
stolid74213183st_oli_d
stolider936603st_olider
stolidest1046113st_olidest
stollen747593st_ollen
stollens835293stollens
stolons73410243st_olons
stomates10313343stomates
stoneflies1343213stoneflies
stones65130033st_o_nes
stonier72013793st_onier
stoniest8413543st_oniest
stooge73811663stoo_ge_
stooged94310733stoo_ged
stooging102810043stooging
stooked124312303stoo_ked
stooker113811733stoo_ker
stookers12449793stookers
stooking132711143stooking
stooks105115373stoo__ks
stool55619893stool___
stooped103813833stoo_ped
stooper93813193stoo_per
stoopers103711303stoopers
stooping113012363stooping
stoops85917893stoo__ps
stopes84525893st_o_pes
stopples1236953stopples
storages9311103storages
storaxes1536883storaxes
stores65533663st_o_res
storied8515163st_oried
stormier1036103stormier
stormiest1137003stormiest
stotins73213873st_otins
stoures74614163st_oures
stourie7469353stourie_
stoves93818923st_o_ves
stowages1236473stowages
strobes93813263stro_bes
strobiles1146953strobiles
strobils1046563strobils
strokes114316323stro_kes
strolled937823strolled
stroller848183stroller
strollers937563strollers
strolls739183strol_ls
strophes13310603strophes
studdies10207073studdies
studies82413863st_udies
studlier935473studlier
studliest1036573studliest
sturdies92110273sturdies
styles94418653st_yl_es
stylise10208953st_ylise
stylises11188943st_ylises
stylites11168693st_ylites
stylizes20207113st_ylizes
stylolites1343653stylolites
stymies1239213st_ymies
sullies74122233s_ullies
supplies1268843supplies
swoonier11185133swoonier
swooniest12176293swooniest
swoopier13175143swoopier
swoopiest14155393swoopiest
swooshes14185123swooshes
tallies73624603_tallies
tellies73820503_tellies
tholes94919783_thol_es
toadies82914863_toadies
tobies84521023_t_obies
toddies93011993_toddies
todies74223553_t_odies
toffies133210213_toffies
toiles63923513_toil_es
toles55147133_t_ol_es
tommies113812983_tommies
tooled74918903_tool_ed
tooler63818613_tool_er
toolers74416503_toolers
tooling82918313_tooling
toolings9248473_toolings
toolless836343_toolless
tools55325243_tool__s
toonie63617993_toonie_
tootles72915603_tootles
tootses72910773_tootses
tootsies848613_tootsies
toplines102412563_toplines
tories65435883_t_ories
towies93521193_t_owies
towlines112610343_towlines
townies103113623_townies
trollies8310233trollies
tsooris734693tsoori_s
twoonies1155693twoonies
whoopies16267373whoopies
woodies113517153_woodies
woolie93514483_woolie_
woolier103612353_woolier
wooliest113011643_wooliest
woollies1147413woollies

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.423422437.4
2DLD Change Limit1461622766.78021557.8
3Display Results2762760.1102509.1
 (SQL Overall)1786912767.31324434.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.