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

419 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
lire4784530(None) 
cire65836381cire
dire56644151dire
fire76245601fire
hire75538971hire
ire36943181_ire
lice66045071lice
lie38264531li_e
lier45942471lier
life75433741life
like86040851like
lime66244941lime
line46965581line
lipe66839741lipe
lira46928691lira
liri45128261liri
lite47054551lite
litre55421461litre
live76541001live
livre85613251livre
lore45850351lore
lure45142461lure
lyre75623791lyre
mire66748241mire
sire46150421sire
tire46143361tire
wire75839821wire
acre67330772acre
afire86215912afire
aide56045012aide
air38058402air_
aired66032922aired
airer54927892airer
airn46433842airn
airs46447432airs
airt45757792airt
airy75734162airy
alike95523962alike
aline57243162aline
alive85722512alive
are37874572_are
bare65460522bare
bice86235572bice
bide76041512bide
bier65531842bier
bike106532612bike
bile66147192bile
bine66650872bine
bird76128332bird
birk106326872birk
birl65830482birl
birle75023632birle
biro66131222biro
birr66022372birr
birse74517402birse
bise66437112bise
bite66547012bite
bize155926302bize
blare75826232blare
blite76225352blite
bore66051332bore
brie65837902brie
byre95023852byre
care66968372care
cere66741472cere
cine66242952cine
cires74932912cires
cite65640352cite
clime95720892clime
cline76428532cline
core67263112core
cure66149122cure
dare55848862dare
dere56845902dere
dice75841902dice
die46759662di_e
dike95935772dike
dime76237652dime
dine55555342dine
direr64927072direr
dirge75117072dirge
dirk96326842dirk
dirl57430032dirl
dirt55550392dirt
dite55547562dite
dive85634782dive
dore56353302dore
dure56341812dure
eide55832252eide
elide64922652elide
elite56230182elite
ere36352772_ere
eyre75525252eyre
fare76354462fare
fere76342232fere
fibre104812842fibre
fice95737122fice
fie67152452fi_e
fife106027712fife
file75446652file
fine75147962fine
fir66744902fir_
fired94829742fired
firer811229252firer
fires85740752fires
firm96026462firm
firn76927512firn
firs76637722firs
five107629752five
flare84823632flare
flier86023402flier
flir76422202flir_
flirs85518932flirs
flirt87424752flirt
flite85424962flite
fore78351472fore
gibe75927792gibe
gie47149552gi_e
gird65425002gird
girl56226562girl
girn56026872girn
giro55828642giro
girt56646432girt
gite55438622gite
give85829362give
glaire74411302glaire
glare65222962glare
glide74521602glide
glime85620192glime
gore55744962gore
gyre84722762gyre
hare76255732hare
here76447102here
hide85134652hide
hie67652712hi_e
hike116830402hike
hired95226262hired
hiree85427802hiree
hirer85423122hirer
hires86134342hires
hive106029682hive
ice56737252_ice
ired55131872_ired
ires45639282_ires
irk76426372_irk
jibe136323402jibe
jive146123602jive
kibe106523462kibe
kier86526822kier
kike76524802kike
kine85643442kine
kir76535692kir_
kirk76221582kirk
kirn87123452kirn
kirs85831752kirs
kite85338252kite
kore85834172kore
lace66848472lace
lade56345992lade
lair45934152lair_
laird65417792laird
laired75216812laired
lairs55425872lairs
lake85741602lake
lame66849292lame
lane45153332lane
lar37967532lar_
lard56742002lard
laree56036302laree
lares54852632lares
large65325462large
lari45839152lari
lark85733862lark
lars46956572lars
lase46148512lase
late47560482late
lave75642142lave
laze136235052laze
lee36068142l_ee
leer46239352leer
leke85527402leke
li29948762li__
liane54720662liane
liar47229692liar
liard65418592liard
liars54723162liars
lib57750282li_b
libel74116102libel
liber74723622liber
libra74712422libra
librae84310172librae
libri74610112libri
libs66732772libs
lich96230852lich
lick106935082lick
lid47453532li_d
lido56028172lido
lids56336472lids
lied55838102lied
lief76037002lief
liege65314432liege
lien45339812lien
lierne638022lierne
liers55130402liers
lies46454202lies
lieu46534372lieu
lieve86315472lieve
lifer85822152lifer
lift76942732lift
liger65024472liger
ligure7279472ligure
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
liras56021982liras
lirot5430032lirot
lis37162282li_s
lisle53916722lisle
lisp68926892lisp
list47055352list
lit39377322li_t
liter54736342liter
lithe84922012lithe
litres65220392litres
lits46252502lits
litu47631572litu
lived95523722lived
liven85021732liven
liver85132962liver
lives86133192lives
livres94311862livres
lobe65535362lobe
lode56240122lode
loge56837192loge
lone45849132lone
lope65941922lope
lord55032082lord
lores55045402lores
lorn46435252lorn
lory75931712lory
lose45144582lose
love75234762love
lowe75435312lowe
lube64731562lube
luce65132572luce
lucre76415522lucre
lude55331652lude
luge55531642luge
lune47140492lune
lured65427492lured
lurer54625312lurer
lures56138532lures
lurex124816732lurex
lurk86624162lurk
lute46341012lute
luxe115222692luxe
lye66533412l_ye
lyres85019962lyres
lyse76320592lyse
mare64759332mare
mere67244442mere
mice87442242mice
mike105535302mike
mile66352582mile
mime85736412mime
mine67256182mine
mir57046782mir_
mired85729222mired
mires75640882mires
mirex146816622mirex
miri66730382miri
mirk106729512mirk
mirs66940582mirs
miry96326762miry
mise66043592mise
mite66249422mite
mitre75522422mitre
moire71017322moire
more67154522more
mure65941332mure
nice65534722nice
nide55535802nide
nine45842182nine
nite45943592nite
nitre57519682nitre
nixe115722032nixe
ogre56320742ogre
olive84817152olive
ore36661832_ore
pare66760842pare
pere66450262pere
pice84641102pice
pie55457412pi_e
pier66035302pier
pike106335222pike
pile65649702pile
pine67755722pine
pipe86434442pipe
pirn67128382pirn
plie65127392pli_e
plier75221282plier
pore66451262pore
pure65543332pure
pyre94925552pyre
quire144917132quire
rare45348432rare
re26153742__re
rice64942922rice
ride55945142ride
rife74632332rife
rile45650542rile
rime65138892rime
ripe66038932ripe
rise45945242rise
rite45849462rite
rive75537732rive
sere46153472sere
shire84727132shire
sice65545602sice
side55444502side
sike87138792sike
sine46560632sine
sipe67341052sipe
sir35746682sir_
sired66134282sired
siree55238812siree
siren54525822siren
sires55945372sires
sirs44338342sirs
site47052422site
size135630972size
slice74925822slice
slide64725422slide
slier54827242slier
slime74925752slime
slipe75626132slipe
sore47059532sore
spire75828692spire
sure45447412sure
tare45957622tare
tide55237392tide
tie36557542ti_e
tier44936152tier
tike85534492tike
tile45451452tile
time66235022time
tine45855142tine
tired65228902tired
tires55437492tires
tirl45029932tirl
tiro46832372tiro
titre54619392titre
tore47359322tore
tyre75428252tyre
vibe95124512vibe
vice95732862vice
vide85432772vide
vie65447642vi_e
vier75428162vier
vile76139812vile
vine75643692vine
vireo84816452vireo
vires84529682vires
virl76224482virl
vise75632682vise
vive105426632vive
ware76254722ware
were76238332were
wide85235422wide
wife105228032wife
wile75944382wile
wine74953432wine
wipe94830292wipe
wired95327642wired
wirer85124952wirer
wires86034912wires
wiry106422842wiry
wise75737352wise
wite75443282wite
wive105931762wive
wore77144672wore
yare75636942yare
yipe96722192yipe
yird87018992yird
yirr76513582yirr
yore76335942yore
zaire14311992zaire
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.280638182.1
2DLD Change Limit298724190.87334217.6
3Display Results4194190.1103809.1
 (SQL Overall)1786914191.263141481.4
 
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.