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

237 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
alexia13291046(None) 
alexias14249791alexias
alexin132311481alexin
abelia83114402abelia
acedia9310392acedia
aecia73819282a_ecia
alevin92511512alevin
alexine142410542alexine
alexins141910662alexins
alodia71112452alodia
anemia82613572anemia
anoxia133510022anoxia
ataxia13179592ataxia
lexica1536102_lexica
lexis125916032_lexis
abasia8712953abasia
abaxial1646183abaxial
abelian92810653abelian
abelias93213563abelias
abulia83512503abulia
acacia10311353acacia
acedias1039773acedias
acequia1844133acequia
aceta74017353ace_ta
acetic10314503acetic
acetin8314693acetin
adaxial1545323adaxial
adnexa1433673adnex_a
aecial84817313a_ecial
aegis6316783a_egis
aerial64625713a_erial
aerie54634603a_erie
agenda837253agenda
agria65517143a_gria
akela9311343ake_la
ala312463603al___a
alanin6317273alanin
alaska1036713alaska
alba68328333al__ba
albata839333albata
albeit8314343albeit
albizia1864093albizia
alcaic1039983alcaic
alcid85817973al_cid
aldrin7311243aldrin
ale36572343ale___
alec66430063ale__c
alecs76620733ale_cs
alee46652323ale__e
alef76340693ale__f
alefs87319663ale_fs
alegar739283alegar
alembic1354773alembic
aleph10311393ale_ph
alephs1136533alephs
alert54740653ale_rt
alerts64418223alerts
ales47067103ale__s
alevins102110573alevins
alewife1344923alewife
alexines15258503alexines
alfa77624273al__fa
alga57927603al__ga
algebra1043043algebra
algid75415583al_gid
algin65718763al_gin
algoid83011473algoid
alias55834603al__ias
alibi7514233alibi_
alibis8311073alibis
alif76242143al__if
alit46155693al__it
aliya83713483al_iya
alkie95520033al_kie
allelic9118173allelic
alleluia843373alleluia
allodia8128793allodia
alluvia1045193alluvia
alma66333023al__ma
alodial899953alodial
aloetic9313183aloetic
aloha8513623al_oha
aloin55227423al_oin
alopecia1244433alopecia
alpaca1047383alpaca
alpha1049653al_pha
althea938213althea
alula5317093al_ula
alumin8513543alumin
alumina9510053alumina
alumna857343alumna
ameba9312383ame_ba
amebic1239113amebic
amentia9310153amentia
amia66836903a__mia
amnesia938293amnesia
amnia75918643a_mnia
amusia839173amusia
anaemia959803anaemia
anemias92512143anemias
anemic102713693anemic
anergia847363anergia
anopia83412393anopia
anorexia1544913anorexia
anoxias14259113anoxias
anoxic152610673anoxic
anuria6313123anuria
apex137220213apex__
apexes1539133apexes
aphelia1249423aphelia
aplasia92510803aplasia
aporia8315863aporia
apraxia1646893apraxia
apteria9312913apteria
area45843393are__a
areca75618633are_ca
areic73219393are_ic
arena55323813are_na
areola6813673areola
arepa75615563are_pa
aria46245423a__ria
asea46327183ase__a
asexual1443983asexual
asteria7316183asteria
ataxias14189343ataxias
ataxic15169203ataxic
atelic8313703atelic
atonia63816513atonia
atresia7310223atresia
atria56022343a_tria
auxin121411913a_uxin
axenic154210003axenic
axial124515193a__xial
axil116424453a__xil
axis116127913a__xis
babesia1146623babesia
cachexia2263583cachexia
calesa8412473cale_sa
camelia11510443camelia
ceria75125353_ceria
cleric10612133cleric
clerid9312413clerid
clevis1158963clevis
clivia1177233clivia
dexie134716893_dexie
dyslexia1942833dyslexia
elegiac1045453elegiac
elegit71212893elegit
elemi7312503elemi_
elemis8312383elemis
elixir1333703elixir
eluvia936133eluvia
exit114428673__exit
feria85922713_feria
flea75628493fle__a
flex146123473flex__
flexed17419093flexed
flexes164512953flexes
flexile1735073flexile
flexing18358993flexing
flexion1735073flexion
flexor1634503flexor
galabia1038333galabia
galea64722943gale__a
galena74911093gale_na
galenic1038693galenic
galleria946483galleria
gleba83910243gle_ba
glia56423153gl__ia
gloria71910553gloria
ilea45931463ile__a
ilex115822033ilex__
ilexes134510253ilexes
ilia46026823il__ia
ixia115713213__ixia
kalmia1238893kal_mia
labia75219013_labia
lamia75324323_lamia
latria62313603latria
lea37660183_le__a
legit61323503_legit
lehua837953_lehua
lei36846383_le_i_
leis45739603_le_is
lemma94811033_lemma
lenis56326863_lenis
lepta75714393_lepta
leva77020713_le_va
levin84816413_levin
levis85818553_levis
lewis85315843_lewis
lex107943823_lex__
lexes127225263_lexes
lexical1637363_lexical
logia68116603_logia
malaria9313703malaria
malefic1486323malefic
media84721713_media
obelia8329453obelia
olea46532723ole__a
olefin937583olefin
oleic7313333ole_ic
olein5316003ole_in
palea75028663pale__a
pallia83015593pal_lia
plea66830603ple__a
pleiad947833ple_iad
plena75816393ple_na
pleura837533pleura
plex137321373plex__
plexal1536843plexal
plexes155313543plexes
plexor1535253plexor
plexus15377283plexus
pyemia1337553pyemia
pyrexia19225463pyrexia
redia65524483_redia
retia55326113_retia
salvia93310753sal_via
sepia75318673_sepia
silesia739083silesia
splenia948313splenia
taenia6313193taenia
talaria7412523talaria
telia55821143_telia
tenia55324483_tenia
ulema7109713ule_ma
ulexite1445723ulexite
uredia73610063uredia
uremia82910893uremia
valencia1343763valencia
valerian1147123valerian
valeric1238303valeric
valonia1048303valonia
vexil1538963_vexil
xenia124814773_xenia
zoecia1735553zoecia

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.373479064.3
2DLD Change Limit1127162375.06322262.7
3Display Results2372370.0802962.5
 (SQL Overall)1786912375.51632395.0
 
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.