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

276 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
liver8513296(None) 
aiver85725161aiver
diver94827801diver
fiver116024941fiver
giver94921201giver
jiver155119051jiver
laver85031791laver
lever85125161lever
liber74723611liber
lier45942461li_er
liever94611861liever
lifer85822151lifer
liger65024461liger
liker95627061liker
liner55938911liner
liter54736341liter
live76540991live_
lived95523721lived
liven85021731liven
livers94927821livers
livery124910891livery
lives86133191lives
livier97514591livier
livre85613251livre
livyer12426291livyer
lover85526451lover
river85731691river
siver85728611siver
sliver94116591sliver
wiver115924511wiver
aider65431132aider
aimer75926822aimer
airer54927892airer
aivers94822322aivers
aliner65621982aliner
alive85722512alive_
aver75931882_aver
bider85728372bider
bier65531822bi_er
biker116022562biker
biner75930692biner
biter75030032biter
caver105629062caver
cider84723312cider
citer74827322citer
civet105828732civet
claver113816972claver
clever114611532clever
clivers123411752clivers
clover114617122clover
cover105430772cover
deliver113312242deliver
dicer85426422dicer
diker105524552diker
dimer85625602dimer
diner65632902diner
direr64927072direr
dive85634772dive_
dived106321372dived
divers105024962divers
divert103922812divert
dives95832402dives
driver104714492driver
eider64624742eider
elver85216242elver
ever77027692_ever
fever115617952fever
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finer85431562finer
firer811229252firer
five107629742five_
fivers124420922fivers
fives116027362fives
fixer154717832fixer
flier86023402fli_er
flivver1633042flivver
giber85417702giber
give85829352give_
given95915282given
givers104817712givers
gives95324872gives
glider84614262glider
glover104513532glover
haver115124462haver
hider95024082hider
hiker125119392hiker
hirer85423122hirer
hive106029672hive_
hived125217912hived
hives116925512hives
hover115524132hover
iller54821292iller
jiber145115702jiber
jive146123592jive_
jived165115042jived
jivers164515642jivers
jives154820812jives
jivey185111872jivey
jivier16438612jivier
kier86526802ki_er
kiter95523212kiter
lacer75833752lacer
lader65633722lader
lager65132862lager
laker95432872laker
lamer75233702lamer
laser54633322laser
later54843922later
lave75642142lave_
laved95028592laved
laveer94110422laveer
lavers94526362lavers
laves86039152laves
laxer125420332laxer
layer84626472layer
leaver94321512leaver
leer46239352l_eer
leger65721502leger
leper74820742leper
levee84023812levee
level84116552level
levers94621322levers
levier94013872levier
liar47229682li_ar
libber104414002libber
libel74116102libel
libers84721432libers
lice66045062lice_
licker125222042licker
lidar6312722lidar
lie38264522li_e_
lied55838092li_ed
lieder74912322lieder
lief76036982li_ef
liefer9529572liefer
lien45339802li_en
liers55130402li_ers
lies46454192li_es
lieu46534362li_eu
lieve86315472lieve
life75433732life_
lifers95617842lifers
lifter93814812lifter
ligers75022022ligers
like86040842like_
liked104523812liked
liken911818842liken
likers104620912likers
likes96231902likes
limber104316772limber
lime66244932lime_
limed85426802limed
limen75426032limen
limes75636502limes
limey104721042limey
limier83518712limier
limmer104314792limmer
limner84112862limner
limper104117852limper
line46965572line_
linear65113332linear
lined64934642lined
linen55728722linen
liners65428842liners
lines57054572lines
liney87029622liney
linger75225992linger
linier64423782linier
linker104321462linker
linter64625332linter
lipe66839732lipe_
lipper104219632lipper
lire47845292lire_
lisper84114432lisper
lister64527252lister
lite47054542lite_
liters65429872liters
lither94520952lither
litre55421462litre
litter64324852litter
lively123310812lively
livener10278932livener
livens94314892livens
livered113111632livered
livest95315732livest
livid96714422livid
liviers104211072liviers
livres94311862livres
livyers13365902livyers
loiter64619172loiter
loner55431032loner
loper75129232loper
loser54728672loser
louver94110392louver
love75234762love_
loved95021362loved
lovers94223432lovers
loves85332012loves
lower85830412lower
luger65322082luger
lurer54625312lurer
miler75733062miler
mimer94825762mimer
miner76933542miner
miser75430402miser
miter75734792miter
mixer145017642mixer
mover104220862mover
naiver94311352naiver
never86218642never
nicer74618292nicer
niter55028972niter
oiler54628282oiler
olive84817152olive_
olives94313952olives
over77227342_over
paver104225832paver
pier66035292pi_er
piker115622842piker
piper96523192piper
plier75221282pli_er
plover115312612plover
quiver18278742quiver
raver85631492raver
reiver95318292reiver
ricer74726612ricer
rider65231302rider
riever94811652riever
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
rive75537722rive_
rived94825612rived
riven85121622riven
rivers94626542rivers
rives85336002rives
rivet85636362rivet
rover85527372rover
saver84831252saver
sever85426052sever
shiver124517372shiver
siker95326032siker
silver93815812silver
sivers95324152sivers
sizer145521812sizer
skiver134612102skiver
slaver94419612slaver
slicer84117602slicer
slider73918362slider
slier54827242sli_er
slivers104115252slivers
stiver93915732stiver
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
titer55430612titer
vier75428152vi_er
viler86324162viler
viper105017302viper
vive105426622vive_
vivers124717362vivers
waiver124212712waiver
waver115025702waver
wider94826352wider
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wive105931752wive_
wived125121502wived
wivern12409282wivern
wivers125320802wivers
wives115328922wives

Search took 3 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 Limit538002761.93627789.3
3Display Results2762760.0803450.0
 (SQL Overall)1786912762.10984727.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.