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

264 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
aider6543113(None) 
abider95314461abider
adder75419591adder
aide56045001aide_
aided75828931aided
aiders74524631aiders
aides65336601aides
aimer75926821aimer
airer54927891airer
aiver85725161aiver
alder65421911alder
arider74717741arider
bider85728371bider
cider84723311cider
eider64624741eider
hider95024081hider
raider74318741raider
rider65231301rider
wider94826351wider
abide86223712abide_
abided105313312abided
abiders104011082abiders
abides94719892abides
abler75624312abler
acrider1038622acrider
added84918432added
adders84315702adders
adieu6417422adieu
aedes64625152aedes
after85719792after
ager55935842a_ger
agger76420892agger
aid49269082aid__
aidmen92610372aidmen
aids57846362aid_s
ailed66240282ailed
aimed85626052aimed
aimers84621912aimers
air38058392ai__r
aired66032922aired
airers64922312airers
airier64619362airier
aivers94822322aivers
alders74218422alders
aliner65621982aliner
alter54828502alter
amber94523212amber
ameer75618982ameer
amide86128482amide_
amides95722662amides
anger66225882anger
aper66336232a_per
apter76120202apter
ardeb8314522ardeb
ardor64617862ardor
armer76924442armer
aside65122082aside_
asides75118872asides
asker96418782asker
asper75520432asper
aster55434892aster
auger64922472auger
aulder7511452aulder
aver75931882a_ver
avoider1155812avoider
azide155617162azide_
azides165113802azides
badder103817512badder
bailer85425252bailer
baiter84422552baiter
balder95318862balder
bander93928222bander
bidder104114862bidder
bide76041502bide_
bided95424962bided
biders94822802biders
bides85536772bides
bidet84935622bidet
bier65531832bi_er
biker116022562biker
binder94422872binder
biner75930692biner
birder94915492birder
biter75030032biter
braider105112992braider
carder94524182carder
ceder85322242ceder
chider125116052chider
ciders94620092ciders
cinder94119122cinder
citer74827332citer
coder86134222coder
cyder114611132cyder
daiker115113032daiker
dander811222992dander
dicer85426422dicer
diker105524552diker
dimer85625602dimer
diner65632902diner
direr64927072direr
diver94827802diver
eide55832242eide_
eiders74321362eiders
elder64020022elder
ender64325862ender
fader94421512fader
fainer94717242fainer
fairer95212062fairer
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finder104020232finder
finer85431562finer
firer811229252firer
fiver116024942fiver
fixer154717832fixer
gadder93714712gadder
gainer74117492gainer
gaiter73819502gaiter
gander84322762gander
giber85417702giber
gilder84415532gilder
girder84312062girder
giver94921202giver
glider84614262glider
guider84313522guider
hailer94720342hailer
hander104526432hander
harder105022402harder
heder95623642heder
hide85134642hide_
hided105222442hided
hiders104919652hiders
hides95129422hides
hiker125119392hiker
hinder104120062hinder
hirer85423122hirer
idea59122772_idea
idem76121062_idem
ides57734232_ides
idler65015662_idler
jailer134316682jailer
jiber145115702jiber
jiver155119052jiver
kaiser103610372kaiser
kidder123811102kidder
kier86526812ki_er
kinder113716842kinder
kiter95523212kiter
ladder84617622ladder
lader65633722lader
lander74028482lander
larder73720972larder
lauder73815012lauder
liber74723622liber
lidar6312722lidar
lieder74912322lieder
lier45942462li_er
lifer85822152lifer
liger65024472liger
liker95627062liker
liner55938922liner
liter54736342liter
liver85132962liver
madder103515592madder
maiden93512282maiden
mailer84724182mailer
maimer104514592maimer
milder93818452milder
miler75733062miler
mimer94825762mimer
minder94822502minder
miner76933542miner
miser75430402miser
miter75734792miter
mixer145017642mixer
nailer64119362nailer
naiver94311352naiver
nicer74618292nicer
nide55535792nide_
nided75920872nided
nides65229132nides
niter55028972niter
nuder66416832nuder
odder74515392odder
oiler54628282oiler
older65121172older
order65019362order
padder103415492padder
pander93725522pander
pier66035292pi_er
piker115622842piker
pinder94523452pinder
piper96523192piper
raided85017702raided
raiders84615142raiders
railer64524932railer
raiser66620102raiser
rapider1067902rapider
ricer74726612ricer
ridder84015142ridder
ride55945132ride_
riders74123902riders
rides66140812rides
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
ruder65320542ruder
sadder82916972sadder
sailer63526102sailer
sander74828532sander
seder64826762seder
side55444492side_
sided74825952sided
sides65838362sides
sidler74716962sidler
siker95326032siker
siver85728612siver
sizer145521812sizer
slider73918362slider
snider74413912snider
spider94516802spider
staider83912612staider
tailer63823732tailer
tide55237382tide_
tided76322512tided
tides64830152tides
tidier73515112tidier
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tinder73821802tinder
titer55430612titer
udder76314282udder
under64624212under
vainer93714572vainer
vide85432762vide_
video96014952video
vier75428152vi_er
viler86324162viler
viper105017302viper
voider103611552voider
wadder114215482wadder
wader95325362wader
wailer93720322wailer
waiter94321252waiter
waiver124212712waiver
wander104423712wander
warder104020272warder
widder112913972widder
wide85235412wide_
widen94717972widen
wides94832822wides
wilder103616472wilder
winder104025262winder
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver
yarder103813972yarder
zander163417112zander

Search took 5 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.423422437.4
2DLD Change Limit538002644.01313406.4
3Display Results2642640.0803300.0
 (SQL Overall)1786912644.51639568.4
 
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.