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

342 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
live7654100(None) 
alive85722511alive
dive85634781dive
five107629751five
give85829361give
hive106029681hive
jive146123601jive
lave75642141lave
lice66045071lice
lie38264531li_e
lieve86315471lieve
life75433741life
like86040851like
lime66244941lime
line46965581line
lipe66839741lipe
lire47845301lire
lite47054551lite
lived95523721lived
liven85021731liven
liver85132961liver
lives86133191lives
livre85613251livre
love75234761love
olive84817151olive
rive75537731rive
vive105426631vive
wive105931761wive
aide56045012aide
aiver85725162aiver
alike95523962alike
aline57243152aline
ave67748702_ave
belive115415302belive
bice86235572bice
bide76041512bide
bike106532612bike
bile66147192bile
bine66650872bine
bise66437112bise
bite66547012bite
bize155926302bize
blite76225352blite
cave95941262cave
chive135117622chive
cine66242952cine
cire65836382cire
cite65640352cite
civet105828732civet
civie103716352civie
clave105420152clave
clime95720892clime
cline76428532cline
clove105619442clove
cove95837072cove
dice75841902dice
die46759662di_e
dike95935772dike
dime76237652dime
dine55555342dine
dire56644152dire
dite55547562dite
diva85920892diva
dived106321372dived
diver94827802diver
dives95832402dives
dove85131562dove
drive95318002drive
eave75733582eave
eide55832252eide
elide64922652elide
elite56230182elite
eve66331162_eve
fave105532962fave
fice95737122fice
fie67152452fi_e
fife106027712fife
file75446652file
fine75147962fine
fire76245602fire
fiver116024942fiver
fives116027362fives
flite85424962flite
gave84634052gave
gibe75927792gibe
gie47149552gi_e
gite55438622gite
given95915282given
giver94921202giver
gives95324872gives
glaive10357932glaive
glide74521602glide
glime85620192glime
glove94516292glove
gyve116215082gyve
have106137072have
hide85134652hide
hie67652712hi_e
hike116830402hike
hire75538972hire
hived125217912hived
hives116925512hives
hove107132222hove
ice56737252_ice
ire36943182_ire
ivy96317452_ivy
jibe136323402jibe
jived165115042jived
jiver155119052jiver
jives154820812jives
jivey185111872jivey
jivy176213122jivy
kibe106523462kibe
kike76524802kike
kine85643442kine
kite85338252kite
kiva116516422kiva
lace66848472lace
lade56345992lade
lake85741602lake
lame66849292lame
lane45153332lane
lase46148512lase
late47560482late
lav66847342lav_
lava76725422lava
laved95028592laved
laver85031792laver
laves86039152laves
lavs76734152lavs
laze136235052laze
leave84723722leave
lee36068142l_ee
leke85527402leke
lev66139422lev_
leva77020712leva
levee84023812levee
level84116552level
lever85125162lever
levo76820062levo
levy106418502levy
li29948762li__
liane54720662liane
liar47229692liar
lib57750282li_b
libel74116102libel
liber74723622liber
libs66732772libs
lich96230852lich
lick106935082lick
lid47453532li_d
lido56028172lido
lids56336472lids
lied55838102lied
lief76037002lief
liege65314432liege
lien45339812lien
lier45942472lier
lies46454202lies
lieu46534372lieu
liever94611862liever
lifer85822152lifer
lift76942732lift
liger65024472liger
liked104523812liked
liken911818842liken
liker95627062liker
likes96231902likes
lilo46731572lilo
lilt46349952lilt
lily76730192lily
lima65734142lima
limb85429392limb
limed85426802limed
limen75426032limen
limes75636502limes
limey104721042limey
limn66527702limn
limo65529742limo
limp88432502limp
limy95727722limy
lin37967382li_n
lined64934642lined
linen55728722linen
liner55938922liner
lines57054572lines
liney87029632liney
ling57447972ling
link86943452link
linn46034602linn
lino46343382lino
lins47059062lins
lint416266242lint
liny78141332liny
lion46334452lion
lip514755812li_p
lipa68425932lipa
lips67141452lips
lira46928692lira
liri45128262liri
lis37162282li_s
lisle53916722lisle
lisp68926892lisp
list47055352list
lit39377322li_t
liter54736342liter
lithe84922012lithe
litre55421462litre
lits46252502lits
litu47631572litu
lively123310812lively
livens94314892livens
livers94927822livers
livery124910902livery
livest95315732livest
livid96714422livid
livier97514592livier
livres94311862livres
livyer12426292livyer
lobe65535362lobe
lode56240122lode
loge56837192loge
lone45849132lone
lope65941922lope
lore45850352lore
lose45144582lose
loved95021362loved
lover85526452lover
loves85332012loves
lowe75435312lowe
lube64731562lube
luce65132572luce
lude55331652lude
luge55531642luge
lune47140492lune
lure45142462lure
lute46341012lute
luv67125772luv_
luvs75818502luvs
luxe115222692luxe
lye66533412l_ye
lyre75623792lyre
lyse76320592lyse
mice87442242mice
mike105535302mike
mile66352582mile
mime85736412mime
mine67256182mine
mire66748242mire
mise66043592mise
mite66249422mite
move96630722move
naive85116212naive
nave75732312nave
neve76224832neve
nice65534722nice
nide55535802nide
nieve85613182nieve
nine45842182nine
nite45943592nite
nixe115722032nixe
ogive9379092ogive
olives94313952olives
pave96133892pave
pice84641102pice
pie55457412pi_e
pike106335222pike
pile65649702pile
pine67755722pine
pipe86434442pipe
plie65127392pli_e
rave75542092rave
reive85522942reive
relive95120782relive
rice64942922rice
ride55945142ride
rife74632332rife
rile45650542rile
rime65138892rime
ripe66038932ripe
rise45945242rise
rite45849462rite
rived94825612rived
riven85121622riven
river85731692river
rives85336002rives
rivet85636362rivet
rove75136982rove
save75741362save
shive114423422shive
sice65545602sice
side55444502side
sieve84918842sieve
sike87138792sike
sine46560632sine
sipe67341052sipe
sire46150422sire
site47052422site
siver85728612siver
size135630972size
skive124614122skive
slave84224032slave
slice74925822slice
slide64725422slide
slieve9359272slieve
slime74925752slime
slipe75626132slipe
sliver94116592sliver
swive115316192swive
tide55237392tide
tie36557542ti_e
tike85534492tike
tile45451452tile
time66235022time
tine45855142tine
tire46143362tire
tivy1014516872tivy
unlive92712332unlive
vibe95124512vibe
vice95732862vice
vide85432772vide
vie65447642vi_e
vile76139812vile
vine75643692vine
vise75632682vise
viva106119102viva
waive114214602waive
wave105234732wave
wide85235422wide
wife105228032wife
wile75944382wile
wine74953432wine
wipe94830292wipe
wire75839822wire
wise75737352wise
wite75443282wite
wived125121502wived
wiver115924512wiver
wives115328922wives
wove105624312wove
yipe96722192yipe
zine137036162zine

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 Filter178691298720.313570897.8
2DLD Change Limit298723420.89033564.0
3Display Results3423420.0804275.0
 (SQL Overall)1786913421.283139275.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.