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

139 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
eluvia93613(None) 
eluvial1045851eluvial
exuvia1644221exuvia
alluvia1045192alluvia
clivia1177232clivia
diluvia11225242diluvia
effluvia1751902effluvia
eluviate1146952eluviate
eluvium1244972eluvium
exuviae1744342exuviae
exuvial1744252exuvial
fluvial1345362fluvial
illuvia1044272illuvia
pluvial1245432pluvial
pluvian1245332pluvian
abulia83512503abulia
alevin92511513alevin
alexia132910463alexia
alluvial1144313alluvial
alodia71112453alodia
alula5317093alu_la
alumin8513543alumin
alumina9510053alumina
alumna857343alumna
amusia839173amusia
anuria6313123anuria
beluga936233belu_ga
bolivia1246063bolivia
celosia939463celosia
clavi104912923clavi_
clevis1158963clevis
clivias1266693clivias
colluvia1343893colluvia
curia74523773_curia
deliria868303deliria
diluvial12224633diluvial
diluvian12194663diluvian
dulia61014983_dulia
effluvial1851603effluvial
elain55324703el_ain
elapid939543elapid
elegiac1045453elegiac
elegit71212893elegit
elemi7312503elemi_
elemis8312383elemis
eleven988303eleven
elevon977953elevon
elfin84312463el_fin
elhi7612403el_hi_
elicit8417203elicit
elixir1333703elixir
elodea738673elodea
eloin55923203el_oin
eluant6315093eluant
eluate62315433eluate
elude64517623elu_de
eluded84612773eluded
eluder73712213eluder
eludes75417683eludes
eluding93412113eluding
eluent6315483eluent
elusion72310953elusion
elusive1057003elusive
elute54822573elu_te
eluted74915263eluted
elutes64020313elutes
eluting84115293eluting
elution72913823elution
eluviated1345333eluviated
eluviates1246103eluviates
eluviums1343863eluviums
elver85216243el_ver
elves85118743el_ves
elvish1277563el_vish
elysian1065083elysian
elytra934893elytra
entia5318203e_ntia
equid154610323equ_id
equip16467263equ_ip
ervil8310303e_rvil
etui45416233etu_i_
etuis54013133etu_is
eulogia846663eulogia
evil75318073e__vil
exurbia1643443exurbia
exuviate1846063exuviate
exuvium1943483exuvium
felucca1442123felucca
flavin1239303flavin
fluid94013963flu_id
glia56423153gl__ia
gloria71910543gloria
helluva1353533helluv_a
ilia46026823il__ia
illuvial1144113illuvial
kelvin13117323kel_vin
labia75219013_labia
lamia75324323_lamia
lava76725423_lav_a
leucin839113leucin
leva77020713_lev_a
levin84816413_levin
levis85818553_levis
livid96714423_livid
logia68116603_logia
lucid84314573_lucid
ludic82912803_ludic
luffa11409023_luffa
luma65527523_lu_ma
lumina84613543_lumina
luna46229853_lu_na
lupin75215843_lupin
lurid64618973_lurid
lutea54819073_lutea
luv67125773_luv__
luvs75818503_luv_s
melodia1038883melodia
nubia7311233_nubia
peculia1147133peculia
peloria9310953peloria
pelvic13307553pel_vic
pelvis113610323pel_vis
petunia966803petunia
pluvials1343713pluvials
pyuria1136953pyuria
refugia1144313refugia
salvia93310753salvia
selva83014273sel_v_a
sequoia1644233sequoia
telia55821143tel__ia
thulia936113thulia
trivia938503trivia
ulva75412693ul_v_a
uvea74712653__uvea
velaria1038923velaria
vesuvian1442593vesuvian
via65636243___via
vulva11448803vulv_a
yautia937253yautia

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.1401276364.3
2DLD Change Limit1127161395.97018880.4
3Display Results1391390.0463021.7
 (SQL Overall)1786911396.15629027.1
 
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.