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

239 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
airer5492789(None) 
aider65431131aider
aimer75926821aimer
aired66032921aired
airers64922311airers
airier64619361airier
aiver85725161aiver
direr64927071direr
fairer95212061fairer
firer811229251firer
hirer85423121hirer
wirer85124951wirer
abider95314462abider
abler75624312abler
acre67330772acre_
acred87126352acred
acres76327762acres
adder75419592adder
admirer1035522admirer
adorer74713452adorer
aerier64823152aerier
afire86215912afire_
after85719792after
ager55935842a_ger
agger76420892agger
agree65226032agree
aide56044992aide_
aided75828932aided
aiders74524632aiders
aides65336602aides
aigret73720022aigret
ailed66240282ailed
aimed85626052aimed
aimers84621912aimers
air38058392ai__r
airest63825262airest
airmen82612352airmen
airn46433832air_n
airns55521032airns
airs46447422air_s
airt45757782air_t
airted74214502airted
airth85621022airth
airts55626342airts
airy75734152air_y
aivers94822322aivers
alder65421912alder
aliner65621982aliner
alter54828502alter
amber94523212amber
ameer75618982ameer
anger66225872anger
aper66336232a_per
apres75426402apres
apter76120202apter
are37874572a_re_
area45843392a_rea
ares45871022a_res
arider74717742arider
ariel55228972ariel
armer76924442armer
arrear6310252arrear
asker96418782asker
asper75520432asper
aspirer967902aspirer
aster55434892aster
auger64922472auger
aurar54420252aurar
aurei54821862aurei
aures55137092aures
aver75931882a_ver
bailer85425252bailer
baiter84422552baiter
barer74535802barer
bider85728372bider
bier65531832bi_er
biker116022562biker
biner75930692biner
birder94915492birder
birler85715082birler
birr66022362bir_r
biter75030032biter
borer75131272borer
brier74527402brier
carer74942332carer
cider84723312cider
cire65836372cire_
cires74932912cires
citer74827332citer
corer75538872corer
crier74724462crier
curer75030752curer
daiker115113032daiker
darer65230792darer
dicer85426422dicer
diker105524552diker
dimer85625602dimer
diner65632902diner
dire56644142dire_
diver94827802diver
drier64423962drier
eider64624742eider
fainer94717242fainer
faired105915772faired
farer86733142farer
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finer85431562finer
fire76245592fire_
fired94829742fired
firers94922682firers
fires85740752fires
firmer114712442firmer
fiver116024942fiver
fixer154717832fixer
frier85225842frier
gainer74117492gainer
gaiter73819502gaiter
giber85417702giber
girder84312062girder
giver94921202giver
hailer94720342hailer
haired105117172haired
hairier103111052hairier
hider95024082hider
hiker125119392hiker
hire75538962hire_
hired95226262hired
hiree85427802hiree
hirers94518062hirers
hires86134342hires
ire36943172_ire_
ired55131872_ired
ires45639282_ires
jailer134316682jailer
jiber145115702jiber
jiver155119052jiver
kaiser103610372kaiser
kier86526802ki_er
kiter95523212kiter
laired75216812laired
liber74723622liber
lier45942462li_er
lifer85822152lifer
liger65024472liger
liker95627062liker
liner55938922liner
lire47845292lire_
liter54736342liter
liver85132962liver
lurer54625312lurer
mailer84724182mailer
maimer104514592maimer
marrer83716672marrer
merer75126232merer
miler75733062miler
mimer94825762mimer
miner76933542miner
mire66748232mire_
mired85729222mired
mires75640882mires
mirex146816622mirex
mirier83918362mirier
mirker123712692mirker
miser75430402miser
miter75734792miter
mixer145017642mixer
nailer64119362nailer
naiver94311352naiver
nicer74618292nicer
niter55028972niter
oiler54628282oiler
paired95017522paired
parer75839902parer
pier66035292pi_er
piker115622842piker
piper96523192piper
prier75027762prier
purer75127902purer
raider74318742raider
railer64524932railer
raiser66620102raiser
rarer54731702rarer
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
sailer63526102sailer
serer55935502serer
siker95326032siker
sire46150412sire_
sired66134282sired
siree55238812siree
siren54525822siren
sires55945372sires
siver85728612siver
sizer145521812sizer
sorer56236582sorer
surer54833092surer
tailer63823732tailer
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tire46143352tire_
tired65228902tired
tires55437492tires
titer55430612titer
trier54328532trier
vainer93714572vainer
varier94619352varier
vier75428152vi_er
viler86324162viler
viper105017302viper
vireo84816452vireo
vires84529682vires
wailer93720322wailer
waired106015832waired
waiter94321252waiter
waiver124212712waiver
warier93722892warier
wider94826352wider
wiper105421292wiper
wire75839812wire_
wired95327642wired
wirers94617892wirers
wires86034912wires
wirier94215552wirier
wiser85522802wiser
wiver115924512wiver
wrier84521752wrier
yarer84321572yarer
yirr76513572yir_r
zaire14311992zaire_
zaires1539702zaires

Search took 9 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.186960704.3
2DLD Change Limit538002397.6737011.6
3Display Results2392390.1401707.1
 (SQL Overall)1786912397.99922339.2
 
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.