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

370 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
lives8613319(None) 
dives95832401dives
fives116027361fives
gives95324871gives
hives116925511hives
jives154820811jives
laves86039151laves
lies46454191li_es
likes96231901likes
limes75636501limes
lines57054571lines
live76540991live_
lived95523721lived
liven85021731liven
livens94314891livens
liver85132961liver
livers94927821livers
livest95315731livest
livres94311861livres
loves85332011loves
olives94313951olives
rives85336001rives
wives115328921wives
aides65336602aides
aiver85725162aiver
aivers94822322aivers
alines65735222alines
alive85722512alive_
aves76142602_aves
bices95029962bices
bides85536772bides
bikes117529472bikes
biles75542142biles
bines76946792bines
bises75435622bises
bites75641172bites
bizes165923662bizes
blites84721212blites
caves105639702caves
chives144317592chives
cines75239682cines
cires74932912cires
cites74435592cites
civet105828732civet
civets115212542civets
civies114116442civies
claves115020062claves
climes104720002climes
clines84926042clines
clivers123411752clivers
cloves114918822cloves
coves105539172coves
dices86434242dices
dies55653522di_es
dikes105831332dikes
dimes85833042dimes
dines66449152dines
dites66339152dites
divas95418582divas
dive85634772dive_
dived106321372dived
diver94827802diver
divers105024962divers
divest106820072divest
doves94728152doves
drives105117112drives
eaves85231992eaves
elides74420692elides
elites66027122elites
elves85118742elves
eves76230462_eves
faves115331422faves
fices106031162fices
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
five107629742five_
fiver116024942fiver
fivers124420922fivers
fixes154723592fixes
flies85630712fli_es
flites95122442flites
gibes84422522gibes
gies55641422gi_es
gites65630182gites
give85829352give_
given95915282given
givens10379732givens
giver94921202giver
givers104817712givers
glaives11347832glaives
glides84518862glides
glimes94717522glimes
gloves104115182gloves
gyves125711552gyves
haves116034872haves
hides95129422hides
hies74842832hi_es
hikes125426982hikes
hires86134342hires
hive106029672hive_
hived125217912hived
ices66129642_ices
ides57734232_ides
ires45639282_ires
ivies84215762_ivies
jibes145520322jibes
jive146123592jive_
jived165115042jived
jiver155119052jiver
jivers164515642jivers
jivey185111872jivey
kibes115521112kibes
kikes85122552kikes
kines95039132kines
kites95432542kites
kivas124614732kivas
knives13458552knives
laces76141762laces
lades65141272lades
lakes95737652lakes
lames75445542lames
lanes54946792lanes
lares54852632lares
lases54944762lases
lavas85422222lavas
lave75642142lave_
laved95028592laved
laver85031792laver
lavers94526362lavers
lavs76734152lav_s
laxes125430092laxes
lazes145129572lazes
leaves94222382leaves
lees45455882l_ees
leges64427282leges
lenes54738522lenes
les35663072l__es
leses54930812leses
levee84023812levee
levees93714522levees
level84116552level
levels94113282levels
lever85125162lever
levers94621322levers
levies93919862levies
levis85818552levis
lexes127225262lexes
lianes63819322lianes
liars54723162liars
libel74116102libel
libels85112692libels
liber74723622liber
libers84721442libers
libs66732762li_bs
lice66045062lice_
liches114724292liches
licks115325392licks
lidos65219882lidos
lids56336452li_ds
lie38264522li_e_
lied55838092li_ed
lief76036992li_ef
lieges74113442lieges
lien45339802li_en
liens56525502liens
lier45942462li_er
liers55130402liers
lieu46534362li_eu
lieus56218482lieus
lieve86315472lieve
liever94611862liever
lievest1048342lievest
life75433732life_
lifer85822152lifer
lifers95617842lifers
lifts85719062lifts
liger65024472liger
ligers75022042ligers
like86040842like_
liked104523812liked
liken911818842liken
likens105613702likens
liker95627062liker
likers104620912likers
likest104914382likest
lilies63021412lilies
lilos55821872lilos
lilts55822802lilts
limas75627632limas
limbs96118942limbs
lime66244932lime_
limed85426802limed
limen75426032limen
limens84618032limens
limey104721042limey
limeys11429272limeys
limns75718392limns
limos75320812limos
limps95522672limps
line46965572line_
lined64934642lined
linen55728722linen
linens64818392linens
liner55938922liner
liners65428852liners
liney87029632liney
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052li_ns
lints57137192lints
lions55923212lions
lipe66839732lipe_
lips67141442li_ps
liras56021982liras
lire47845292lire_
lis37162272li__s
lisles63416282lisles
lisps76913912lisps
lists56628692lists
litas54923772litas
lite47054542lite_
liter54736342liter
liters65429882liters
litres65220392litres
lits46252492li_ts
lively123310812lively
livery124910902livery
livid96714422livid
livier97514592livier
liviers104211072liviers
livre85613252livre
livyer12426292livyer
livyers13365902livyers
loaves94813852loaves
lobes75331002lobes
lodes66436912lodes
loges66534202loges
lopes76437342lopes
lores55045402lores
loses56742012loses
love75234762love_
loved95021362loved
lover85526452lover
lovers94223432lovers
lowes85732462lowes
loxes125227472loxes
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552l_ues
luges65928752luges
lunes55337772lunes
lures56138532lures
lutes55836662lutes
luvs75818502luv_s
luxes124921502luxes
lyes75530832l_yes
lyres85019962lyres
lyses84518252lyses
mikes115129892mikes
miles74645072miles
mimes95732022mimes
mines75651952mines
mires75640882mires
mises74740562mises
mites75141802mites
mixes147224402mixes
moves106128422moves
naives94914222naives
naves87030382naves
neves87021872neves
nides65229132nides
nieves94311292nieves
nines55937342nines
nites55736342nites
nixes124519622nixes
oaves84925612oaves
ogives10367912ogives
olive84817152olive_
paves104833922paves
pies66949602pi_es
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pixes144323172pixes
plies74526512pli_es
raves85441972raves
reives95723042reives
relives104619442relives
ribes75530172ribes
rices75536152rices
rides66140812rides
riles55343642riles
rimes75634542rimes
ripes75435772ripes
rises55244042rises
rites54442552rites
rive75537722rive_
rived94825612rived
riven85121622riven
river85731692river
rivers94626542rivers
rivet85636362rivet
rivets94417112rivets
roves84834482roves
saves85838632saves
shives124921412shives
sices75637272sices
sides65838362sides
sieves93216002sieves
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
siver85728612siver
sivers95324152sivers
sixes124526362sixes
sizes146727762sizes
skives134113942skives
slaves95023022slaves
slices84022852slices
slides73922182slides
slieves10378962slieves
slimes84722042slimes
slipes84921412slipes
sliver94116592sliver
slivers104115252slivers
swives123915182swives
tides64830152tides
ties45248312ti_es
tikes95628902tikes
tiles55542102tiles
times75630822times
tines54848422tines
tires55437492tires
unlives102010952unlives
vibes104719952vibes
vices105725532vices
vies75238622vi_es
vines85137642vines
vires84529682vires
vises84427772vises
vivas114815022vivas
vive105426622vive_
vivers124717362vivers
waives123714182waives
waves115633922waves
wides94832822wides
wifes114522562wifes
wiles85437872wiles
wines85546862wines
wipes104827082wipes
wires86034912wires
wises85633192wises
wites85536962wites
wive105931752wive_
wived125121502wived
wiver115924512wiver
wivers125320802wivers
wizes174723342wizes
yikes125117752yikes
yipes106017842yipes
zines145232652zines

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.0931921408.6
2DLD Change Limit538003701.62333148.5
3Display Results3703700.0963854.2
 (SQL Overall)1786913701.81298615.3
 
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.