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

171 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
zodiac183530(None) 
zodiacs1943421zodiacs
iodic84816752iodi_c
modica11310062modica
odic74920582_odi_c
oomiac1037062oomiac
podia8415282podia_
sodic84917492sodi_c
zodiacal2042242zodiacal
zoic152316072zo_i_c
alodia71112453alodia_
alodial899953alodial
anodic92813133anodi_c
asdic83814093asdi_c
audial7312993audial
azoic162912063azo_i_c
azonic175513153azoni_c
azotic172711633azoti_c
bodice11711423bodice
bodied103814583bodied
bodies94524143bodies
bodily12310993bodily
boding104320063boding
boric98024223bori_c
cardiac1278823cardiac
celiac101910433celiac
cobia94117513cobia_
cobias104014993cobias
coda77029353cod_a_
codas84724243cod_as
codec107120343cod_ec
codeia94112193codeia_
codeias103911223codeias
codify1537163codify
coding104024793coding
coeliac1138233coeliac
cognac1157273cognac
colic95726173coli_c
comic114721813comi_c
conic95329793coni_c
cordial10312953cordial
coria75828323coria_
corsac10410173corsac
dial55935073__dial
disc76123243__disc
domic104317243domi_c
eolian6312593eolian
eonian6311833eonian
folia83618933folia_
foliar93210973foliar
folic105319323foli_c
geodic1048003geodi_c
goddam1145163goddam
gonia64117533gonia_
guaiac946153guaiac
heliac111010893heliac
hodad10311353hod_ad
iliac75013493_iliac
iodid74315533iodi_d
iodide84812933iodide
iodids83711153iodids
iodin64419353iodi_n
iodine74618653iodine
iodins74216523iodins
iodise74214943iodise
iodism93611133iodism
iodize164112593iodize
ionic74622663ioni_c
jovial1636543jovial
logia68116603logia_
logic88217833logi_c
lorica8310443lorica
lotic76420673loti_c
ludic82912803ludi_c
maniac103917973maniac
media84721713media_
mediacy1536143mediacy
mediad104313713mediad
mediae94217413mediae
medial93819863medial
median94117543median
medias93620783medias
medic104619653medi_c
medivac1554693medivac
modal85919243mod_al
modi76826323modi__
modify1537173modify
modish123813543modish
mosaic10311143mosaic
nodal64717793nod_al
nodi56626753nodi__
nodical1049863nodical
nordic939473nordi_c
noria55722183noria_
norias65518203norias
obia67923113_obia_
obias76116863_obias
oda48133053_od_a_
odah87018933_od_ah
odas57230263_od_as
odea56224573_odea_
odist6421913_odist
odium83413033_odium
ohia75719363_ohia_
ohias84415573_ohias
oidia6314963oidia_
oomiack1544223oomiack
oomiacs1135683oomiacs
oomiak1235353oomiak
orgiac934993orgiac
otic66624823_oti_c
ovisac1153953_ovisac
ozonic17308943ozoni_c
podite93315353podite
poditic122611583poditic
podium112911913podium
pudic104614563pudi_c
radial74020393radial
radian74117273radian
redia65524483redia_
rediae74221993rediae
redial74923113redial
redias74523613redias
rhodic12227233rhodi_c
rodman949713rodman
social8813333social
soda56329393sod_a_
sodas64123543sod_as
sodium92111453sodium
sonic75225293soni_c
today96416953tod_ay
todies74223553todies
tombac12258883tombac
tonic74727653toni_c
topic95721503topi_c
toric76529313tori_c
toxic145315623toxi_c
triac74116373_triac
umiac938963_umiac
vodka1354343vodka_
vodkas1443543vodkas
vomica1336383vomica
yogic116114933yogi_c
yonic105920843yoni_c
zamia165115213zamia_
zamias174212923zamias
zinc156819103z__inc
zoa128529993zo__a_
zoaria1548383zoaria_
zoarial1646923zoarial
zoea137118423zo_ea_
zoeae144412483zo_eae
zoeal144813783zo_eal
zoeas145815613zo_eas
zoecia1735553zoecia_
zona136321963zo_na_
zonae145116443zo_nae
zonal145116853zo_nal
zoning162914333zoning
zooid15312103zooi_d
zooidal1745093zooidal
zooids1637093zooids
zooier153411233zooier
zoonal1558083zoonal
zori137722923zori__
zoril143916693zori_l
zorils153810883zorils
zoris145320013zori_s
zowie174313843zowi_e
zoysia1844163zoysia_
zoysias1943843zoysias

Search took 6 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.376475242.0
2DLD Change Limit1127161714.84323274.0
3Display Results1711710.0463717.4
 (SQL Overall)1786911715.26533939.4
 
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.