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

244 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
lairs5542587(None) 
airs46447421_airs
fairs85825441fairs
flairs95711911flairs
glairs75211331glairs
hairs86225171hairs
laics76419251laics
lair45934151lair_
laird65417791laird
lairds74711611lairds
laris54737461laris
lars46956571la_rs
liars54723161liars
mairs76228291mairs
pairs75325831pairs
vairs85019131vairs
wairs86424061wairs
aids57846352_aids
ails45654712_ails
aims67738182_aims
ains46158882_ains
air38058392_air_
airn46433832_airn
airns55521032_airns
airt45757782_airt
airts55626342_airts
airy75734152_airy
ais39083572_ai_s
aits46355532_aits
alias55834602alias
alifs86121262alifs
amirs75924912amirs
ars37670932_a_rs
bails75933522bails
bairn77515532bairn
bairns86710872bairns
baits76630582baits
bars66564092ba_rs
blains84516372blains
caids85226422caids
cains75334302cains
caird85717232caird
cairds96411512cairds
cairn75717512cairn
cairns85313302cairns
carrs75730852carrs
cars67364762ca_rs
chairs114916172chairs
claims105211572claims
coirs75221052coirs
dairy97016302dairy
dais57040702dai_s
deairs74013782deairs
ears46356592ea_rs
eclairs935962eclairs
elains64919852elains
emirs76116152emirs
fails85631482fails
fair76332522fair_
fairy115318282fairy
fakirs13468082fakirs
faqirs18456032faqirs
fiars86720832fiars
firs76637712_firs
flails94313002flails
flair86114122flair_
flirs85518932flirs
gains65729512gains
gaits65726012gaits
gars55750742ga_rs
gaurs66317992gaurs
glair65313552glair_
glaire74411292glaire
glaires84010132glaires
glairy10448272glairy
haars85620472haars
haiks125120932haiks
hails85231642hails
hair76330142hair_
hairy115316832hairy
heirs85618562heirs
jails125422942jails
jars117338352ja_rs
kafirs13306982kafirs
kaifs125715642kaifs
kails95525212kails
kains96125642kains
keirs95313672keirs
kirs85831732_kirs
laari54415712laari
labors84016402labors
labra75415462labra
labs67145122la_bs
lacers85225252lacers
laces76141762laces
lacks116129202lacks
lacs66942482la_cs
laders74927762laders
lades65141272lades
ladies75124882ladies
lads56549132la_ds
lagers74826142lagers
lags56546222la_gs
lahars94013162lahars
laic65931562lai_c
laich105920712laich
laichs115110892laichs
laid56439142lai_d
laigh95515922laigh
laighs10508802laighs
lain46146282lai_n
laired75216812laired
laith85722102laith
laity85318902laity
lakers105225152lakers
lakes95737652lakes
lakhs125210342lakhs
lalls55324132lalls
lamas75532792lamas
lambs95921412lambs
lames75445542lames
lamias85020612lamias
lamps95624832lamps
lams66552262la_ms
lands65426902lands
lanes54946792lanes
lapins84520682lapins
lapis76223152lapis
laps66848872la_ps
lar37967532la_r_
lard56742002la_rd
lards65331862lards
lares54852632lares
lari45839152la_ri
lark85733862la_rk
larks95227812larks
las37281472la__s
lasers64925702lasers
lases54944762lases
lass47444542la_ss
lasts57731262lasts
laths86022402laths
lats45962702la_ts
lauds65618482lauds
laura54116202laura
lauras63414332lauras
lavas85422222lavas
lavers94526362lavers
laves86039152laves
lavs76734152la_vs
lawns85215422lawns
laws76441682la_ws
laxes125430092laxes
layers93921182layers
layins93817652layins
lays76043252la_ys
lazars153812392lazars
lazes145129572lazes
lazies154418782lazies
lears55938732lears
leers54828982leers
lehrs86111132lehrs
leis45739602lei_s
liar47229682liar_
liard65418592liard
liards75212612liards
libs66732752l_ibs
lids56336452l_ids
liers55130402liers
lies46454192l_ies
lins47059052l_ins
lips67141442l_ips
lira46928682l_ira
liras56021982l_iras
lire47845292l_ire
liri45128252l_iri
lis37162272l_i_s
lits46252492l_its
loids66220702loids
loins56728422loins
loris55329152loris
lours55125292lours
maars74621632maars
maids86327132maids
mails76037772mails
maims96321782maims
mains75635092mains
mair66133762mair_
mars66261862ma_rs
mirs66940562_mirs
nadirs7109002nadirs
naifs87617422naifs
nails55730402nails
naira5314742naira
nairas6312772nairas
nairu5413812nairu
nairus639142nairus
naris55735292naris
noirs55615462noirs
oars46846032oa_rs
paiks114719852paiks
pails75833062pails
pains75138282pains
pair66031512pair_
paris75145942paris
parrs75928672parrs
pars67560792pa_rs
plaids94312442plaids
plains85019592plains
plaits83816472plaits
qaids156116312qaids
raias54631122raias
raids65827512raids
rails55937402rails
rains55140232rains
rais45252622rai_s
sabirs85414622sabirs
saids65328852saids
sails55738102sails
sains55639972sains
saris54544952saris
sirs44338332_sirs
stairs65416332stairs
stirs55921612stirs
tahrs85412332tahrs
tails55634192tails
tains54936322tains
tapirs84113172tapirs
tars46763952ta_rs
vails85825932vails
vair75624142vair_
vars75742072va_rs
waifs115719872waifs
wails86631482wails
wains86930862wains
wair75830052wair_
waits88333522waits
wars78659802wa_rs
weirs84316492weirs
whirs115218092whirs
yaird96111912yaird
yairds10448022yairds
zaire14311992zaire
zaires1539702zaires

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 Limit538002441.87628678.0
3Display Results2442440.0633873.0
 (SQL Overall)1786912442.03287938.5
 
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.