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

248 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
liger6502447(None) 
lager65132861lager
leger65721511leger
liber74723621liber
lier45942461li_er
lifer85822151lifer
ligers75022041ligers
liker95627061liker
liner55938921liner
linger75226001linger
liter54736341liter
liver85132961liver
luger65322081luger
tiger65718631tiger
ager55935842_ager
agger76420892agger
aider65431132aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
aligner8108312aligner
aliner65621982aliner
anger66225872anger
auger64922472auger
bider85728372bider
bier65531832bi_er
bigger104315062bigger
biker116022562biker
biner75930692biner
binger94923452binger
biter75030032biter
cager85229222cager
cider84723312cider
cigar8911802cigar
citer74827332citer
clinger103812152clinger
dicer85426422dicer
digger94616082digger
diker105524552diker
dimer85625602dimer
diner65632902diner
dinger85323672dinger
direr64927072direr
diver94827802diver
eager65526972eager
edger75215952edger
eger55923572_eger
egger74414412egger
eider64624742eider
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finer85431562finer
finger104920332finger
firer811229252firer
fiver116024942fiver
fixer154717832fixer
flier86023402fli_er
flinger113710512flinger
gager74726292gager
giber85417702giber
ginger84920032ginger
giver94921202giver
glider84614262glider
hider95024082hider
higher134610892higher
hiker125119392hiker
hinger104723332hinger
hirer85423122hirer
huger94914872huger
iller54821292iller
jager134318132jager
jiber145115702jiber
jigger155313052jigger
jiver155119052jiver
kier86526812ki_er
kiter95523212kiter
laager74312782laager
lacer75833752lacer
lader65633722lader
lagers74826142lagers
lagger85919832lagger
laker95432872laker
lamer75233702lamer
larger74417512larger
laser54633322laser
later54843922later
laver85031792laver
laxer125420332laxer
layer84626472layer
ledger85914392ledger
leer46239352l_eer
legers74518312legers
leges64427292leges
leper74820742leper
lever85125162lever
liar47229682li_ar
libber104414012libber
libel74116102libel
libers84721442libers
lice66045062lice_
licker125222042licker
lidar6312722lidar
lie38264522li_e_
lied55838092li_ed
lieder74912322lieder
lief76036992li_ef
liefer9529572liefer
liege65314432liege
lieges74113442lieges
lien45339802li_en
liers55130402li_ers
lies46454192li_es
lieu46534362li_eu
liever94611862liever
life75433732life_
lifers95617842lifers
lifter93814812lifter
ligan67920282ligan
light94429602light
lighter113113442lighter
ligure7279472ligure
like86040842like_
liked104523812liked
liken911818842liken
likers104620912likers
likes96231902likes
limber104316792limber
lime66244932lime_
limed85426802limed
limen75426032limen
limes75636502limes
limey104721042limey
limier83518722limier
limmer104314792limmer
limner84112872limner
limper104117852limper
line46965572line_
linear65113342linear
lined64934642lined
linen55728722linen
liners65428852liners
lines57054572lines
liney87029632liney
lingers84223302lingers
lingier84113382lingier
linier64423792linier
linker104321472linker
linter64625342linter
lipe66839732lipe_
lipper104219632lipper
lire47845292lire_
lisper84114432lisper
lister64527252lister
lite47054542lite_
liters65429882liters
lither94520952lither
litre55421462litre
litter64324852litter
live76540992live_
lived95523722lived
liven85021732liven
livers94927822livers
livery124910902livery
lives86133192lives
livier97514592livier
livre85613252livre
livyer12426292livyer
lodger86517692lodger
loge56837192loge_
loges66534202loges
logger86420002logger
logier75015732logier
loiter64619172loiter
loner55431042loner
longer75823202longer
loper75129232loper
loser54728672loser
lover85526452lover
lower85830412lower
luge55531642luge_
luged74019092luged
lugers74617022lugers
luges65928752luges
lugger83916552lugger
lunger75720422lunger
lurer54625312lurer
miler75733062miler
mimer94825762mimer
miner76933542miner
miser75430402miser
miter75734792miter
mixer145017642mixer
nicer74618292nicer
nigger89713572nigger
nigher103612752nigher
niter55028972niter
obliger1035282obliger
oiler54628282oiler
pager84728202pager
pier66035292pi_er
piker115622842piker
pinger94324092pinger
piper96523192piper
plier75221282pli_er
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rigger85616712rigger
rigor62714052rigor
rimer75429242rimer
ringer74526062ringer
riper74328402riper
riser55431052riser
river85731692river
roger64521412roger
sager65432052sager
sigher103813702sigher
signer74015632signer
siker95326032siker
singer74227312singer
siver85728612siver
sizer145521812sizer
slicer84117602slicer
slider73918362slider
slier54827242sli_er
slinger83413832slinger
sliver94116592sliver
tier44936142ti_er
tigers75616512tigers
tiler56131022tiler
timer75626042timer
titer55430612titer
urger64116472urger
veliger1137312veliger
vier75428152vi_er
vigor92612422vigor
viler86324162viler
viper105017302viper
wager95925052wager
wider94826352wider
winger104125442winger
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver
yager95616752yager
zinger163816702zinger

Search took 4 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.343520965.0
2DLD Change Limit538002482.65620256.0
3Display Results2482480.0604133.3
 (SQL Overall)1786912483.05958414.8
 
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.