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

293 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
alodia7111245(None) 
allodia8128791allodia
alodial899951alodial
acedia9310392acedia
alexia132910462alexia
allodial9117392allodial
alodium1047582alodium
aloha8513612alo_ha
aloin55227422alo_in
anodic92813132anodic
anopia83412392anopia
anoxia133510022anoxia
aporia8315862aporia
atonia63816512atonia
elodea738672elodea
gloria71910542gloria
logia68116602_logia
melodia1038882melodia
podia8415282_podia
valonia1048302valonia
abasia8712953abasia
abelia83114403abelia
abode85518813abod_e
aboded104912513aboded
abodes94417513abodes
aboding11410123aboding
aboil72217543abo_il
abolla8410193abolla
aboma91114603abo_ma
aboulia966553aboulia
abrosia939273abrosia
abulia83512503abulia
acacia10311353acacia
accidia1246993accidia
acedias1039773acedias
acholia1239973acholia
acidic113612133acidic
acromia1139963acromia
adit56443653a__dit
adonis7314063adonis
aecia73819283a_ecia
aecidia1047283aecidia
aeolian738623aeolian
aeonian738353aeonian
aeonic83517043aeonic
aerobia939463aerobia
agnosia837643agnosia
agonic93515143agonic
agora6914333ago_ra
agria65517143a_gria
aioli5318313aioli_
aiolis6316843aiolis
ala312463603al___a
alanin6317273alanin
alaska1036713alaska
alba68328333al__ba
albata839333albata
albeit8314343albeit
albizia1864093albizia
alcaic1039983alcaic
alcid85817973al_cid
alcids94812293alcids
alder65421913al_der
aldol61212333al_dol
aldols7109713aldols
aldose7311093aldose
aldrin7311243aldrin
alevin92511513alevin
alexias14249793alexias
alexin132311483alexin
alfa77624273al__fa
alforja1782303alforja
alga57927603al__ga
algid75415583al_gid
algin65718763al_gin
algoid83011473algoid
alias55834603al__ias
alibi7514233alibi_
alibis8311073alibis
alidad838883alidad
alif76242143al__if
alit46155693al__it
aliya83713483al_iya
alkie95520033al_kie
allod64418383allod__
allodium1145783allodium
allods73615083allod_s
alluvia1045193alluvia
alma66333023al__ma
aloe45540193alo__e
aloes54933673alo_es
aloetic9313183aloetic
aloft8423433alo_ft
alogical1147763alogical
alohas9411703alohas
aloins65022203aloins
alone55732963alo_ne
along65419493alo_ng
aloof83521573alo_of
alopecia1244433alopecia
aloud65018073alo_ud
alow75328593alo__w
alpaca1047383alpaca
alpha1049653al_pha
althea938193althea
aludel747853aludel
alula5317093al_ula
alumin8513543alumin
alumina9510053alumina
alumna857343alumna
amia66836903a__mia
amidic114012873amidic
amidin94015673amidin
ammonia1148693ammonia
amnia75918643a_mnia
amoeba1035603amoeba
amusia839173amusia
anemia82613573anemia
anoa45634473ano__a
anodal72512123anodal
anode65021033anod_e
anodes74418753anodes
anodize1738673anodize
anomic102516303anomic
anomie83215963anomie
anopias92412483anopias
anopsia9258443anopsia
anosmia946643anosmia
anoxias14259113anoxias
anoxic152610673anoxic
anthodia1247803anthodia
anuria6313123anuria
aorta55922573a_orta
aphonia122711883aphonia
aplasia92510803aplasia
apod78123183apod__
apodal9289833apodal
apods86316343apod_s
apologia1147723apologia
aporias9315153aporias
arcadia1039703arcadia
aria46245423a__ria
aroid65428343aro_id
aroids75118223aroids
aroma71220143aro_ma
ascidia1046683ascidia
asdic83814093a_sdic
asocial998653asocial
ataxia13179593ataxia
atomic104115603atomic
atonias73315993atonias
atonic83420473atonic
atopic103514143atopic
atria56022343a_tria
audial7312993a_udial
audio62917103a_udio
audit62527883a_udit
avidin103510843avidin
avodire1143763avodire
avoid95516683avo_id
avoids104410203avoids
axonic154312723axonic
azoic162912063azo_ic
azonic175513153azonic
azotic172711633azotic
basidia1047613basidia
blooie83913193blooie
caloric113413223caloric
calorie92716893calorie
cardia9916373cardia
celosia939463celosia
clivia1177233clivia
cloaca1037263cloaca
clod76124613clod__
cloddy13405233cloddy
clods85320863clod_s
clonic104914673clonic
cobia94117513_cobia
coda77029343_cod_a
codeia94112193_codeia
coria75828323_coria
elodeas836963elodeas
eloin55923203elo_in
eluvia936133eluvia
emodin9310353emodin
eulogia846663eulogia
exordia1544983exordia
flooie93712153flooie
flora85317103flo_ra
florid10311453florid
florin9312653florin
flota85315643flo_ta
folia83618933_folia
foodie104413843foodie
galabia1038323galabia
geodic1048003geodic
glia56423153gl__ia
globin9309723globin
glorias81610323glorias
glossa7529163glossa
gonia64117533_gonia
goodie83613993goodie
haloid104317763halo_id
haloids113012553haloids
haplopia1544783haplopia
hoodie105116143hoodie
ilia46026823il__ia
iodic84816753_iodic
iodid74315533_iodid
iodin64419353_iodin
ixodid15215763ixodid
kalmia1238893kal_mia
labia75219013_labia
laddie83713173laddie
lamia75324323_lamia
laogai735983laogai
latria62313593latria
loca65527683_lo_ca
lochia1158313_lochia
loci66126283_loci_
lode56240113_lod_e
loden66621143_loden
lodes66436913_lodes
lodge76520083_lodge
loggia8457053_loggia
logic88217833_logic
login66025003_login
loid55531493_lo_id
loids66220703_loids
loin46838723_lo_in
loofa85912813_loofa
looie55624243_looie
lorica8310443_lorica
loris55329153_loris
lota47233503_lo_ta
loti46431843_loti_
lotic76420673_lotic
louie55023513_louie
louis57322323_louis
louma76213633_louma
ludic82912803_ludic
mahonia1238443mahonia
malaria9313693malaria
malodor1044563malodor
maloti8313213maloti_
media84721713_media
melodias1148703melodias
melodic1238543melodic
melodica1344983melodica
modi76826313_modi_
modica11310063_modica
myopia13318443myopia
nodi56626743_nodi_
noria55722183_noria
obia67923113__obia
oda48133043__od_a
odea56224573__odea
odic74920573__odic
ohia75719363__ohia
oidia6314953_oidia
oldie6415473ol_die
pagoda10487873pagod_a
paladin101011773paladin
palladia1146633palladia
pallia83015593pal_lia
palooka1344503palooka
parodic122311723parodic
peloria9310953peloria
phobia13278603phobia
plod76723273plod__
plods85719293plod_s
ploidy1237483ploidy
redia65524483_redia
rhodic12227233rhodic
salvia93310753sal_via
scoria8513503scoria
scotia8310803scotia
sloid64619713slo_id
sloids73712693sloids
soda56329383_sod_a
sodic84917493_sodic
soldi65717203soldi_
stadia7312143stadia
talaria7412513talaria
talooka1143493talooka
thoria93012893thoria
uredia73610063uredia
utopia8107883utopia
valonias1147473valonias
vodka1354343_vodka
woodie103513613woodie
woodsia1144173woodsia
zodiac1835303_zodiac

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.1431249587.4
2DLD Change Limit1127162935.50020493.8
3Display Results2932930.0933150.5
 (SQL Overall)1786912935.73631152.5
 
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.