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

240 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
lived9552372(None) 
dived106321371dived
hived125217911hived
jived165115041jived
laved95028591laved
lied55838091li_ed
liked104523811liked
limed85426801limed
lined64934641lined
live76540991live_
liven85021731liven
liver85132961liver
lives86133191lives
livid96714421livid
loved95021361loved
rived94825611rived
wived125121501wived
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
aiver85725162aiver
alined75221402alined
aliped95414282aliped
alive85722512alive_
bided95424962bided
biked125320032biked
biped104718832biped
caved116227562caved
cited84421952cited
civet105828732civet
coved115027372coved
diced95824682diced
died66137852di_ed
diked115024682diked
dined76431992dined
dive85634772dive_
diver94827802diver
dives95832402dives
eaved95924502eaved
elided84814672elided
fifed125115972fifed
filed95331902filed
fined94930502fined
fired94829742fired
five107629742five_
fiver116024942fiver
fives116027362fives
fixed165416952fixed
flied96519432fli_ed
flited104616582flited
gibed96215962gibed
gied64631982gi_ed
give85829352give_
given95915282given
giver94921202giver
gives95324872gives
glaived12375972glaived
glided94513902glided
glimed105312282glimed
gloved114811872gloved
gyved13568742gyved
hided105222442hided
hied85434042hi_ed
hiked135919202hiked
hired95226262hired
hive106029672hive_
hives116925512hives
iced78721892_iced
ired55131872_ired
ivied94710522_ivied
jibed155114162jibed
jive146123592jive_
jiver155119052jiver
jives154820812jives
jivey185111872jivey
kited105120092kited
laced87132642laced
laded74232612laded
laired75216812laired
laked105731122laked
lamed85235292lamed
lased65132342lased
lated65240672lated
lave75642142lave_
laver85031792laver
laves86039152laves
lawed96028322lawed
layed95127382layed
lazed154925842lazed
leaved105719022leaved
led46254552l__ed
levee84023812levee
leveed104111372leveed
level84116552level
lever85125162lever
levied104111432levied
liard65418592liard
libel74116102libel
liber74723622liber
lice66045062lice_
licked134621562licked
lid47453512li__d
lidded93410242lidded
lie38264522li_e_
lief76036992li_ef
lien45339802li_en
lier45942462li_er
lies46454192li_es
lieu46534362li_eu
lieve86315472lieve
liever94611862liever
life75433732life_
lifer85822152lifer
lifted104413522lifted
liger65024472liger
like86040842like_
liken911818842liken
liker95627062liker
likes96231902likes
lilied73913212lilied
lilted73715372lilted
limbed114513182limbed
lime66244932lime_
limen75426032limen
limes75636502limes
limey104721042limey
limned94811472limned
limped114817122limped
line46965572line_
linen55728722linen
liner55938922liner
lines57054572lines
liney87029632liney
linked114518212linked
linted74021822linted
lipe66839732lipe_
lipid85916172lipid
lipped114419542lipped
lire47845292lire_
lisped94113422lisped
listed74322832listed
lite47054542lite_
liter54736342liter
lively123310812lively
livened11238932livened
livens94314892livens
livered113111632livered
livers94927822livers
livery124910902livery
livest95315732livest
livier97514592livier
livre85613252livre
livres94311862livres
livyer12426292livyer
lobed86022132lobed
loided83414022loided
looed64626132looed
loped85128332loped
love75234762love_
lover85526452lover
loves85332012loves
lowed95233902lowed
loxed135017052loxed
lubed85319892lubed
luged74019092luged
lured65427492lured
luted64826142luted
lysed95011562lysed
miked125020452miked
mimed105622732mimed
mined85333352mined
mired85729222mired
mixed155717252mixed
moved114218152moved
nided75920872nided
nixed135714222nixed
oiled64429472oiled
olive84817152olive_
olives94313952olives
paved115525262paved
pied75035362pi_ed
piked125623312piked
piled85232992piled
pined85935322pined
piped105123162piped
plied85118592pli_ed
raved94931432raved
reived104518132reived
relived115114682relived
riced85825542riced
riled65833252riled
rimed84826372rimed
riped85226432riped
rive75537722rive_
riven85121622riven
river85731692river
rives85336002rives
rivet85636362rivet
roved95323552roved
saved95127112saved
sided74825952sided
sieved104611442sieved
siped84927682siped
sired66134282sired
sited65130742sited
siver85728612siver
sized155519242sized
skived14429892skived
slaved104017042slaved
sliced94416312sliced
slimed94915122slimed
sliped95417062sliped
sliver94116592sliver
swived133610632swived
tided76322512tided
tied55535212ti_ed
tiled64832942tiled
timed85223612timed
tined65434532tined
tired65228902tired
unlived112511372unlived
viced115118182viced
vied86328632vi_ed
vined95626152vined
vised95518762vised
vive105426622vive_
vivid125112312vivid
waived134511282waived
waved125223582waved
wifed125117742wifed
wiled95231552wiled
wined94434182wined
wiped114722082wiped
wired95327642wired
wised95123342wised
wited94727142wited
wive105931752wive_
wiver115924512wiver
wives115328922wives

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 Limit538002401.75030742.9
3Display Results2402400.0633809.5
 (SQL Overall)1786912401.90693751.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.