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

207 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
lifer8582215(None) 
fifer115519971fifer
liber74723611liber
liefer9529571liefer
lier45942461li_er
life75433731life_
lifers95617841lifers
lifter93814811lifter
liger65024461liger
liker95627061liker
liner55938911liner
liter54736341liter
liver85132961liver
rifer84721981rifer
aider65431132aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
aliner65621982aliner
bider85728372bider
bier65531822bi_er
biker116022562biker
biner75930692biner
biter75030032biter
cider84723312cider
citer74827322citer
defer94619752defer
dicer85426422dicer
differ133910842differ
diker105524552diker
dimer85625602dimer
diner65632902diner
direr64927072direr
diver94827802diver
eider64624742eider
fer66646122__fer
fiber104921132fiber
fife106027702fife_
fifed125115972fifed
fifers125414922fifers
fifes114822392fifes
filer85433002filer
finer85431562finer
firer811229252firer
fiver116024942fiver
fixer154717832fixer
flier86023402fli_er
giber85417702giber
giver94921202giver
glider84614262glider
gofer94814282gofer
heifer1238202heifer
hider95024082hider
hiker125119392hiker
hirer85423122hirer
iller54821292iller
infer84215032infer
jiber145115702jiber
jiver155119052jiver
kier86526802ki_er
kiter95523212kiter
knifer13598562knifer
lacer75833752lacer
lader65633722lader
lager65132862lager
laker95432872laker
lamer75233702lamer
laser54633322laser
later54843922later
laver85031792laver
laxer125420332laxer
layer84626472layer
leer46239352l_eer
lefter93613432lefter
leger65721502leger
leper74820742leper
lever85125162lever
liar47229682li_ar
libber104414002libber
libel74116102libel
libers84721432libers
lice66045062lice_
licker125222042licker
lidar6312722lidar
lie38264522li_e_
lied55838092li_ed
lieder74912322lieder
lief76036982li_ef
lien45339802li_en
liers55130402li_ers
lies46454192li_es
lieu46534362li_eu
liever94611862liever
lift76942722lif_t
lifted104413522lifted
lifters104313772lifters
lifts85719062lifts
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
live76540992live_
lived95523722lived
liven85021732liven
livers94927822livers
livery124910892livery
lives86133192lives
livier97514592livier
livre85613252livre
livyer12426292livyer
loafer93610942loafer
lofter94614722lofter
loiter64619172loiter
loner55431032loner
loper75129232loper
loser54728672loser
lover85526452lover
lower85830412lower
lucifer1234602lucifer
luger65322082luger
lurer54625312lurer
miler75733062miler
mimer94825762mimer
miner76933542miner
miser75430402miser
miter75734792miter
mixer145017642mixer
nicer74618292nicer
niffer12378442niffer
niter55028972niter
offer114311382offer
oiler54628282oiler
pier66035292pi_er
piker115622842piker
pilfer1139162pilfer
piper96523192piper
plier75221282pli_er
refer84822142refer
ricer74726612ricer
rider65231302rider
rife74632322rife_
rifler94014262rifler
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
safer84721812safer
sifter94516232sifter
siker95326032siker
siver85728612siver
sizer145521812sizer
slicer84117602slicer
slider73918362slider
slier54827242sli_er
sliver94116592sliver
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
titer55430612titer
titfer9409522titfer
vier75428152vi_er
viler86324162viler
viper105017302viper
wafer114417642wafer
wider94826352wider
wife105228022wife_
wifed125117742wifed
wifes114522562wifes
wifey144913672wifey
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver

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 Limit538002071.70331591.3
3Display Results2072070.0633285.7
 (SQL Overall)1786912071.85996122.1
 
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.