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 “elves” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

157 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
elves8511874(None) 
delves104917081delves
eaves85231991eaves
elver85216241elver
elvers93814981elvers
eves76230461e_ves
helves124316061helves
pelves114514661pelves
selves94119611selves
ales47067102al_es
almes75126542almes
aloes54933672aloes
aves76142602_aves
beeves114615042beeves
belies84631052belies
belles85325992belles
blues75127042blues
calves115119282calves
caves105639702caves
claves115020062claves
cloves114918822cloves
clues74623032clues
coves105539172coves
deaves105319532deaves
deles65139252del_es
delve96018262delve_
delved114112752delved
delver104913492delver
delvers113411992delvers
dives95832402dives
doves94728152doves
eases56041612eases
eave75733582eave_
eaved95924502eaved
eches106322162eches
edges75718742edges
ekes86726602e_kes
elans55527752elans
elates65032362elates
elder64020022elder
elders74817302elders
eldest72912682eldest
elds56324852el_ds
eleven988302eleven
elevens1066802elevens
elides74420692elides
elites66027122elites
elks85820032el_ks
ells46431352el_ls
elms67322702el_ms
elopes85918162elopes
els37645722el__s
else45923082else_
eludes75417682eludes
elutes64020312elutes
elvish1277562elvish
emes65434662e_mes
envies9314052envies
epees75219832epees
ernes55224812ernes
erses55826802erses
eses45336102e_ses
esnes54817362esnes
esses56422972esses
eve66331162e_ve_
even75222272e_ven
evens84817102e_vens
ever77027692e_ver
evolves13286742evolves
ewes76328702e_wes
exes116530812e_xes
eyes75837882e_yes
eyres84921772eyres
faves115331422faves
fives116027362fives
flees85828752flees
flies85630712flies
floes85528142floes
flues84626922flues
gelees74116262gelees
gives95324872gives
glees65027592glees
gloves104115182gloves
glues65125682glues
gyves125711552gyves
halves124717092halves
haves116034872haves
heaves124120302heaves
helve115018092helve_
helved134313702helved
hives116925512hives
jives154820812jives
keeves133711992keeves
laves86039152laves
leaves94222382leaves
lees45455882_lees
leges64427292leges
lenes54738522lenes
les35663072_l_es
leses54930812leses
levee84023812levee
levees93714522levees
level84116552level
levels94113282levels
lever85125162lever
levers94621322levers
levies93919862levies
levis85818552levis
lexes127225262lexes
lies46454192_lies
lives86133192lives
loves85332012loves
lues45943552_lues
lyes75530832_lyes
melees83618082melees
moves106128422moves
naves87030382naves
nerves94216192nerves
neves87021872neves
oaves84925612oaves
oles46453472ol_es
olives94313952olives
paves104833922paves
peeves113814872peeves
peles75738082pel_es
pelvis113610322pelvis
plies74526512plies
raves85441972raves
reaves94127572reaves
reeves94721492reeves
reives95723042reives
releves103914972releves
relies65036422relies
relives104619442relives
rives85336002rives
roves84834482roves
salves94221762salves
saves85838632saves
selles64426982selles
selvas93812912selvas
serves94423652serves
shelves134112092shelves
slaves95023022slaves
sloes54728872sloes
slues54527172slues
solves95018222solves
teles54536002tel_es
twelves1334302twelves
ulvas84511502ulvas
valves124113782valves
velvet123613752velvet
velvets13326692velvets
verves124617882verves
waves115633922waves
weaves123616372weaves
wives115328922wives
wolves124510852wolves

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001571.42337807.4
3Display Results1571570.0463413.0
 (SQL Overall)1786911571.782100275.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.