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

218 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
liars5472316(None) 
fiars86720831fiars
lairs55425871lairs
lars46956571l_ars
lears55938731lears
liar47229681liar_
liard65418591liard
liards75212611liards
lidars7310781lidars
liers55130401liers
liras56021981liras
afars85716512afars
agars66120642agars
airs46447422ai_rs
alias55834602alia_s
altars64518152altars
ars37670932__ars
bars66564092_bars
bears75739042bears
bias64738162bia_s
biers76225222biers
birrs74917102birrs
blears85116452blears
boars75229602boars
briars84814822briars
cars67364762_cars
chars105936642chars
cigars9910722cigars
clears84116562clears
czars164812912czars
dears65736882dears
dials64925342dials
diary95016972diary
dinars75417562dinars
ears46356592_ears
fairs85825442fairs
fears84829392fears
fiar76427332fiar_
fiats85324482fiats
firs76637712fi_rs
flairs95711912flairs
fliers94417192fliers
flirs85518932fli_rs
friars93812092friars
gars55750742_gars
gears64628692gears
glairs75211332glairs
glias64618492glia_s
gnars66718852gnars
guars65021052guars
haars85620472haars
hairs86225172hairs
hears86737372hears
hoars85925552hoars
iliads7448672iliads
izars145112932izars
jars117338352_jars
kbars114612602kbars
kiers95320092kiers
kirs85831742ki_rs
knars94416112knars
kyars124813962kyars
laari54415712laari
labs67145122l_abs
lacs66942482l_acs
lads56549132l_ads
lags56546222l_ags
lahars94013162lahars
laics76419252laics
lair45934152lair_
laird65417792laird
lairds74711612lairds
lams66552262l_ams
laps66848872l_aps
lar37967532l_ar_
lard56742002l_ard
lards65331862l_ards
lares54852632l_ares
lari45839152l_ari
laris54737462l_aris
lark85733862l_ark
larks95227812l_arks
las37281472l_a_s
lass47444542l_ass
lats45962702l_ats
lavs76734152l_avs
laws76441682l_aws
lays76043252l_ays
lazars153812392lazars
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lear47045952lear_
learn55322662learn
learns65513742learns
leary85927382leary
leas45954182lea_s
leers54828982leers
lehrs86111132lehrs
liaise6310692liaise
liana53915892liana
lianas63713382lianas
liane54720662liane
lianes63819322lianes
liang64914412liang
liangs74410592liangs
libers84721442libers
libra74712422libra
libras83711702libras
libri74610112libri
libs66732762li_bs
licks115325392licks
lidar6312722lidar_
lidos65219882lidos
lids56336462li_ds
liens56525502liens
lier45942462lier_
lies46454192li_es
lieus56218482lieus
lifers95617842lifers
lifts85719062lifts
ligans76817732ligans
ligers75022042ligers
likers104620912likers
likes96231902likes
lilacs837482lilacs
lilos55821872lilos
lilts55822802lilts
limans84816302limans
limas75627632limas
limbs96118942limbs
limes75636502limes
limns75718392limns
limos75320812limos
limps95522672limps
linacs8310812linacs
liners65428852liners
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052li_ns
lints57137192lints
lions55923212lions
lips67141442li_ps
lira46928682li_ra
lire47845292li_re
liri45128252li_ri
lis37162272li__s
lisps76913912lisps
lists56628692lists
litas54923772litas
liters65429882liters
litre55421462litre
litres65220392litres
lits46252492li_ts
livers94927822livers
lives86133192lives
livre85613252livre
livres94311862livres
lizard16369232lizard
lizards17427612lizards
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
lours55125292lours
luaus54514902luaus
lunars65012812lunars
lyard95113212lyard
lyart85121882lyart
maars74621632maars
mairs76228302mairs
mars66261872_mars
mirs66940572mi_rs
nears55529422nears
oars46846032_oars
pairs75325832pairs
pars67560792_pars
pears75138612pears
pians75126962pians
pias66542552pia_s
piers75926332piers
pliers84715152pliers
rears54739652rears
rials55026672rials
rias45540592ria_s
roars55622242roars
scars75433532scars
sears54744912sears
sials54227242sials
simars84916932simars
sirs44338332si_rs
sitars65417592sitars
sizars154812622sizars
soars54732512soars
spars75431542spars
stars55836572stars
tars46763952_tars
tears55436462tears
tiara5315912tiara
tiaras6314552tiaras
tiers55526522tiers
tsars56717112tsars
tzars144914272tzars
vairs85019132vairs
vars75742072_vars
vials85822382vials
vicars11712262vicars
viers85621952viers
wairs86424062wairs
wars78659802_wars
wears86030302wears
years84527672years
yirrs8469192yirrs

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.296603685.8
2DLD Change Limit538002181.61033416.1
3Display Results2182180.0464739.1
 (SQL Overall)1786912181.95291542.5
 
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.