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

312 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
zombie193732(None) 
zombi1838991zombi_
zombies2037991zombies
zombis1936281zombis
bombe115519312bomb_e
boobie104015292boobie
combe116223542comb_e
combine133014722combine
commie124215522commie
corbie103618202corbie
dobie84920332do_bie
doobie94712682doobie
hombre13309302hombre
homie104622532hom_ie
lambie103213672lambie
ombre94111802_ombre
pommie123710502pommie
sombre10729472sombre
wombier1436542wombier
zombify2642252zombify
zowie174313842zo_wie
ambit94223713_ambit
amble95924643_amble
amie66339853_am_ie
anomie83215963anom_ie
barbie105018353barbie
bobbies103714563bobbies
bobbin93410733bobbin
bobble94115143bobble
boccie123311453boccie
bogie89524103bo_gie
bomb106927423bomb__
bombax1935753bombax
bombed134113873bombed
bomber125014653bomber
bombes124916823bombes
bombing143211393bombing
bomblet13412263bomblet
bombs115818823bomb_s
bombyx2232693bombyx
bonnie85314853bonnie
boobies113718203boobies
boogie93515993boogie
bookie123516003bookie
bootie85421163bootie
bougie93613273bougie
bumble124216893bumble
cabbie122913353cabbie
cambia124913153cambia
cammie124615293cammie
cobbier133410163cobbier
cobble123615263cobble
cobia94117513co_bia
coble94823173co_ble
collie83621993collie
comade114415323comade
comae97128423com_ae
comake144413423comake
comate104124843comate
comb106632113comb__
combat12316753combat
combed135516543combed
comber125118503comber
combes125321733combes
combined15269183combined
combiner14259723combiner
combines142814623combines
combing143714733combing
comblike1846293comblike
combo114519433comb_o
combos125316613combos
combs116122963comb_s
come87547703com__e
comfier1439163comfier
comfit133112423comfit
comic114721813com_ic
comix163513203com_ix
commies133718453commies
commit124016703commit
commix19407763commix
comose105016853comose
compile13312443compile
comte96125473com_te
cookie123716043cookie
coolie83821603coolie
coombe124110093coomb_e
cootie84223093cootie
corbies113520123corbies
corrie83621233corrie
cosie74728273co_sie
cowpie133511513cowpie
cowrie113814283cowrie
cozie163519133co_zie
cumbia12379893cumbia
doable93115243doable
dobbies124113063dobbies
dobbin11339523dobbin
dobies94422093do_bies
doggie93910893doggie
dogie75222793do_gie
domain9511323domain
domaine10610503domaine
dome77240733dom__e
domic104317243dom_ic
domine92918253domine
dominie103111643dominie
donsie7613643donsie
doobies103915673doobies
doolie73916833doolie
doozie163910653doozie
dormie9312623dormie
double94013993double
dowie94721143do_wie
doxie136017153do_xie
fimble133611753fimble
fogie96719003fo_gie
foible11410383foible
folkie13369613folkie
fomite113314073fomite
foodie104413843foodie
footie94718143footie
forbid123312433forbid
forbye14427883forbye
fumble133214263fumble
gambe106219213gamb_e
gambia115912253gambia
gambier124711973gambier
gambir11509773gambir
gambit114714213gambit
gamble115417183gamble
gimmie11298183gimmie
goalie7413163goalie
gobble113512983gobble
gobies95418063go_bies
gombeen1243733gombeen
gombo105814043gomb_o
gombos114311093gombos
goodie83613993goodie
goonie73615563goonie
hempie132410563hempie
hoagie102310013hoagie
hobbies143813343hobbies
hobbit132810543hobbit
hobble133913433hobble
hogtie102711773hogtie
homage121210603homage
hombres14369883hombres
home98042443hom__e
homier116416993hom_ier
homies114524733hom_ies
honkie133011673honkie
hoodie105116143hoodie
hoolie93217783hoolie
hottie92514383hottie
howdie13349733howdie
humble133615053humble
iambi95512223iambi_
iambic12468283iambic
imbibe1234703_imbibe
imbue939483_imbue
jambe165314753jamb_e
jimmie17376473jimmie
jumble174012653jumble
kebbie1435813kebbie
kombu1347243komb_u
kombus1435523kombus
kookie9389843kookie
koppie14277883koppie
lambier113611643lambier
lambies113015113lambies
limbi96513813limbi_
limbic12528743limbic
limbier11349113limbier
lobbied12337173lobbied
lobbies113612463lobbies
lobe65535363lo_b_e
loggie84011993loggie
lomein8410203lomein
loobies93814103loobies
looie55624243lo_oie
loonie64216453loonie
louie55023513lo_uie
mamie95826003mam_ie
mammie94313783mammie
mobile103613543mo_bile
moggie103210103moggie
mollie83517103mollie
mome85239353mom__e
momi87524483mom_i_
mommies103912273mommies
monie75631653mo_nie
morbid112511463morbid
movie105319133mo_vie
moxie144018123mo_xie
mumble123614343mumble
newbie11135413newbie
nimbi94910313nimbi_
nimble103412943nimble
nobbier11309163nobbier
nobble103814313nobble
noble74420993no_ble
nombles113212343nombles
nombril1145103nombril
nome66038423nom__e
nomoi76012533nomoi_
noogie73612313noogie
nookie103712433nookie
obe56638643_o_b_e
obi57127733_o_bi_
obia67923113_o_bia
obis66226843_o_bis
obit66837083_o_bit
oboe66822943_o_boe
oldie6415473_oldie
omber95316443_omber
ombres103911143_ombres
omit65337373_om_it
oorie53026363_oorie
orbier839993_orbier
orbit73622063_orbit
ourie54027303_ourie
pomace123111913pomace
pomade113611333pomade
pome85636693pom__e
pommee122813283pommee
pommies133712843pommies
popsie103013063popsie
postie84123963postie
potpie103412433potpie
potsie83916033potsie
ramble104519973ramble
ramie75027823ram_ie
rhombi13365203rhombi_
rhombic16264533rhombic
roadie72813813roadie
robbin103611183robbin
robe65335643ro_b_e
robin74820283ro_bin
roble75223023ro_ble
romaine9512123romaine
roofie93411173roofie
rookie103613263rookie
roomie83013873roomie
rouble83913313rouble
rumble103718813rumble
softie93312483softie
somber103714003somber
some66040383som__e
somite84519373somite
sonsie6614863sonsie
sorbic10310393sorbic
sortie63621993sortie
soubise9118793soubise
tammie104212693tammie
timbre10328633timbre
tobies84521023to_bies
tomb89029653tomb__
tombac12258883tombac
tombak14237753tombak
tombal102311023tombal
tombed113812133tombed
tombing123310533tombing
tomblike1645143tomblike
tomboy1358213tomboy
tombs97818733tomb_s
tome67543193tom__e
tommies113812983tommies
tomtit8413853tomtit
toonie63617993toonie
towie85821873to_wie
townie93312303townie
tumble103215643tumble
vogie95116663vo_gie
vomit102622573vom_it
wamble134415753wamble
wimble133211923wimble
wobble133212313wobble
womb117022233womb__
wombat1339863wombat
wombed14419233wombed
wombiest1536893wombiest
wombs125813343womb_s
womby155910093womb_y
woodie103513613woodie
woolie93514483woolie
yabbie13308663yabbie
yomim12510083yom_im
yowie114616453yo_wie
zamia165115213zam_ia
zoaria1548383zoaria
zoeae144412483zo_eae
zoecia1735553zoecia
zoftig1932973zoftig
zoic152316073zo__ic
zoisite1635833zoisite
zombified2642843zombified
zombifies2543213zombifies
zombiism2342433zombiism
zonae145116443zo_nae
zonate154114923zonate
zone135231083zo__ne
zonule1577483zonule
zooid15312103zo_oid
zooier153411233zo_oier
zootier163611173zootier
zori137722923zo_ri_
zoril143916693zo_ril
zoris145320013zo_ris
zouave1833573zouave
zoysia1844163zoysia
zymase201997483zymase
zyme1819114943zym__e

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 Filter1786911127160.750238254.7
2DLD Change Limit1127163125.78019501.0
3Display Results3123120.0963250.0
 (SQL Overall)1786913126.62626968.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.