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

165 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
hoochies163959(None) 
hooches153812521hooch_es
hoochie1537781hoochie_
conchies153214852conchies
cooches143515832cooch_es
hoodies113419832hoo_dies
hookies144017442hoo_kies
hootches1656972hootch_es
hotches153814362hotch_es
mooches143714452mooch_es
pooches143214162pooch_es
biochips1744843biochips
boccies133311513_boccies
boches134618523_boch_es
bolshies1338693bolshies
boobies113718203boo_bies
boodies103721443boo_dies
boogies103719013boo_gies
bookies133819403boo_kies
boonies93422483boo_nies
booties94124613boo_ties
botches143716023botch_es
botchier15287143botchier
botchiest1636153botchiest
bothies12414783_bothies
bouchees15339533bouchees
boychiks2242933boychiks
brooches15288193brooch_es
cloches144113713cloch_es
coaches144018693coach_es
cochins141413093_cochins
conches144019813conch_es
conchie143312683conchie_
cookies133719273coo_kies
coolies93824963coo_lies
coonties10513793coonties
cooties93725733coo_ties
couches144020463couch_es
dhoolies1246963dhoo_lies
dhooties1237633dhoo_ties
doobies103915673doo_bies
doodies94218773doo_dies
doolies83920713doo_lies
doozies173812723doo_zies
douches134315233douch_es
duchies133312313_duchies
foodies113416753foo_dies
footies103721543foo_ties
footsies1139643footsies
glochids1543953glochids
goodies93516993goo_dies
googlies1086763googlies
goonies83618333goo_nies
hackies163418243h_ackies
hatches153420273hatch_es
hickies163614743h_ickies
hitches153616273hitch_es
hoagies112811993h_oagies
hobbies143813343h_obbies
hocuses121710423h_ocuses
hoecakes1745323hoecakes
hogties112813993h_ogties
holies94630033h_o_lies
hollies103420813h_ollies
homies114524723h_o_mies
homilies132710113homilies
hominies133012953hominies
homophiles2048213homophiles
honchoed1745733honchoed
honchos15369573honch_os
hongies112716473h_ongies
honkies143015143h_onkies
hooch135813703hooch___
hoodie105116133hoo_die_
hoodier113812973hoo_dier
hoodiest122413173hoo_diest
hookier143811673hoo_kier
hookiest152712103hoo_kiest
hoolie93217773hoo_lie_
hoopoes121212483hoo_poes
hootier104915343hoo_tier
hootiest113115643hoo_tiest
hooves124815483hoo__ves
hotcakes1744703hotcakes
hotched163610923hotch_ed
hotching17309313hotching
hotties103016953h_otties
hourlies1138343hourlies
howdies142911953h_owdies
hunches153913463hunch_es
hutches153613523hutch_es
isochimes16103743isochimes
loaches123613983loach_es
loobies93814103loo_bies
looies65025833loo__ies
loonies73919543loo_nies
mooched153910533mooch_ed
moocher143610673mooch_er
moochers15369123moochers
mooching16259063mooching
mouches143815963mouch_es
munchies1539253munchies
nitchies1339073nitchies
noogies82814583noo_gies
nookies113414963noo_kies
notches123513653notch_es
ochres113510833__ochres
oocytes1246063_oocytes
orchids1377213_orchids
orchils1277703_orchils
orchis11710773_orchi_s
orchises1338773_orchises
ouches114322183_ouch_es
poaches144416943poach_es
poachier1556823poachier
poachiest1636883poachiest
pooched152810083pooch_ed
pooching16328983pooching
porches143815673porch_es
pouches144116743pouch_es
pouchier1546803pouchier
pouchiest1636843pouchiest
roaches123616213roach_es
roofies103014413roo_fies
rookies113917103roo_kies
roomies93017243roo_mies
rotches123515703rotch_es
rouches124217893rouch_es
roughies1298323roughies
scooches15188413scooch_es
shooflies1544123shooflies
smooches15217263smooch_es
smoothies1456123smoothies
soothes103917103sooth_es
sophies12314603_sophies
soroches1338803soroch_es
techies12513603_techies
toonies73719883too_nies
toothier1136423toothier
toothiest1237523toothiest
tootsies848613tootsies
torches123715433torch_es
torchier1337463torchier
torchiers1445073torchiers
torchiest1438033torchiest
touches125118343touch_es
touchier1347383touchier
touchiest1437083touchiest
toughies1278243toughies
trochees132510183trochees
troches123715343troch_es
trochils1388583trochils
trophies13413673trophies
vichies15310623_vichies
vouchees16337483vouchees
vouches153914113vouch_es
whoopies16267363whoo_pies
whooshes1734413whoosh_es
woodies113517153woo_dies
woolies104117363woo_lies
woollies1147413woollies
wooshes13169883woosh_es
worthies14310283worthies
zoochores2345953zoochores
zoophiles2356523zoophiles

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.1561145455.1
2DLD Change Limit1461621658.48317230.0
3Display Results1651650.0632619.0
 (SQL Overall)1786911658.70220534.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.