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

126 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
hoochie153779(None) 
hoochies1639601hoochies
conchie143312682conchie
hooch135813702hooch__
hooches153812522hooches
hoodie105116132hoo_die
hoolie93217772hoo_lie
biochip1645323biochip
boccie123311453_boccie
boche124216953_boch_e
bolshie1247123bolshie
boobie104015293boo_bie
boogie93515993boo_gie
bookie123516003boo_kie
bootie85421153boo_tie
botchier15287143botchier
bouchee143313543bouchee
boychik2143943boychik
broche133612103broch_e
cloche134312373cloch_e
cochin131313203_cochin
conchae143911643conchae
conchies153214853conchies
cooch124916833cooch__
cooches143515833cooches
cookie123716043coo_kie
coolie83821603coo_lie
coontie9311423coontie
cootie84223083coo_tie
couthie121810553couthie
dhootie1136463dhoo_tie
doobie94712683doo_bie
doolie73916833doo_lie
doozie163910643doo_zie
douche124613223douch_e
foodie104413843foo_die
footie94718133foo_tie
footsie1047643footsie
glochid1445263glochid
goodie83613993goo_die
goonie73615563goo_nie
hackie154615623h_ackie
hickie153812473h_ickie
hoagie102310003h_oagie
hoecake1645203hoecake
hogtie102711763h_ogtie
holocene1346143holocene
holocrine1495333holocrine
homie104622523h_o_mie
homophile1948103homophile
honcho14389383honch_o
honchoed1745733honchoed
honchos15369573honchos
honkie133011663h_onkie
hoodier113812973hoo_dier
hoodies113419833hoo_dies
hoodlike1636563hoodlike
hooflike1834853hooflike
hookier143811673hoo_kier
hookies144017443hoo_kies
hooklike1435123hooklike
hooplike1736773hooplike
hoopoe11911233hoo_poe
hootch14386403hootch__
hootches1656973hootches
hootier104915343hoo_tier
hotcake1644543hotcake
hotch136214723hotch__
hotched163610923hotched
hotches153814363hotches
hotching17309313hotching
hottie92514373h_ottie
howdie13349723h_owdie
isochime15113843isochime
kookie9389833koo_kie
lochia1158313_lochia
looie55624243loo__ie
loonie64216453loo_nie
louche115212663louch_e
macchie1647193macchie
mooch125313613mooch__
mooched153910533mooched
moocher143610673moocher
mooches143714453mooches
mooching16259063mooching
nitchie1247233nitchie
noogie73612313noo_gie
nookie103712433noo_kie
ochre103411593__ochre
oocyte1135753_oocyte
oorie53026363_oo_rie
orchid1289573_orchid
orchil1158653_orchil
orchis11710773_orchis
poachier1556823poachier
pooch124815303pooch__
pooched152810083pooched
pooches143214163pooches
pooching16328983pooching
pouchier1546803pouchier
rhonchi1542493rhonchi_
roofie93411173roo_fie
rookie103613263roo_kie
roomie83013873roo_mie
rotche114311983rotch_e
rouche114714313rouch_e
smoothie1344883smoothie
soothe94214843sooth_e
soroche1237183soroch_e
techie11511723_techie
toonie63617993too_nie
toothier1136423toothier
tootsie737123tootsie
torchier1337463torchier
touche114916173touch_e
touchier1347383touchier
toughie1187593toughie
troche113112513troch_e
trochee122613883trochee
trochil1258713trochil
vouchee153411263vouchee
whoopie15295923whoo_pie
woodie103513613woo_die
woolie93514483woo_lie
zoochore2245783zoochore
zoophile2246453zoophile

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271268.04616657.6
3Display Results1261260.0502520.0
 (SQL Overall)1786911268.25221654.3
 
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.