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

130 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
alodial89995(None) 
allodial9117391allodial
alodia71112451alodia_
allodia8128792allodia_
alodium1047582alodium
alogical1147762alogical
anodal72512122anod_al
apodal9289832apod_al
asocial998652asocial
audial7312992a_udial
abaxial1646183abaxial
aboding11410123aboding
aboil72217543abo_i_l
aboral8314373abo_ral
acedia9310393acedia_
acedias1039773acedias
acromial1248463acromial
adagial946373adagial
adaxial1545323adaxial
aecial84817313a_ecial
aecidial1147253aecidial
aeolian738623aeolian
aeonian738353aeonian
aerial64625713a_erial
agonal7410053ago_nal
albinal937813albinal
aldol61212333al_d_ol
alexia132910463alexia_
alexias14249793alexias
algal66518223al__gal
alias55834603al__ias
alidad838883alid_ad
allheal1044553allheal
allodium1145783allodium
alluvial1144313alluvial
aloha8513613alo_ha_
alohas9411703alo_has
aloin55227423alo_i_n
aloins65022203alo_ins
aludel747863alud_el
amoral8314633amo_ral
anodic92813133anodi_c
anodize1738683anodize
anopia83412393anopia_
anopias92412483anopias
anoxia133510023anoxia_
anoxias14259113anoxias
aortal65217513a_ortal
apogeal1045623apogeal
aporia8315863aporia_
aporias9315153aporias
apsidal1046703apsidal
armorial1049453armorial
arousal748633arousal
asocials1075683asocials
atomical1248903atomical
atonal6514023ato_nal
atonia63816513atonia_
atonias73315993atonias
atrial65418943a_trial
avodire1143763avodire
avowal1246323avo_wal
axial124515193a__xial
axonal1347653axo_nal
azonal1568273azo_nal
baronial1049483baronial
basidial1145623basidial
chorial124214143chorial
cladodial1342853cladodial
cloacal1135163cloacal
clonal8310913clo_nal
colonial10411343colonial
cordial10312943cordial
dial55935063___dial
elodea738673elodea_
elodeas836963elodeas
eluvial1045853eluvial
exordial1645313exordial
floral94313813flo_ral
fluidal1144653fluidal
fluvial1345363fluvial
geoidal936713geoidal
glacial1038143glacial
glial66715433gl__ial
global937663glo_bal
gloria71910543gloria_
glorias81610323glorias
glossal8447053glossal
glottal835103glottal
hyoidal1444803hyoidal
ilial55317843il__ial
jovial1636543_jovial
keloidal1344103keloidal
labial84714343_labial
local74820273_lo_cal
lochial1257083_lochial
logia68116603_logia_
logical1038513_logical
loral55927823_lo_ral
loreal63814313_loreal
loyal84513483_lo_yal
malarial10410613malarial
manorial10311083manorial
medial93819863_medial
melodia1038883melodia_
melodias1148703melodias
misdial1039643misdial
modal85919243_mod_al
nodal64717793_nod_al
nodical1049863_nodical
ovoidal1144023ovoidal
palatial10410623palatial
pallial92911253pal_lial
paludal1035683palud_al
parodical1447563parodical
pluvial1245433pluvial
podia8415283_podia_
predial103815413predial
prodigal1246003prodigal
radial74020393_radial
rasorial848223rasorial
redial74923113_redial
social8813333_social
sundial859863sundial
uredial82910483uredial
uxorial1446323uxorial
valonia1048303valonia_
valonias1147473valonias
zodiac1835303_zodiac
zooidal1745093zooidal

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271306.03022226.7
3Display Results1301300.0462826.1
 (SQL Overall)1786911306.46627635.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.