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

289 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
fader9442151(None) 
facer105525051facer
fade85736351fade_
faded105025241faded
faders105117461faders
fades94932861fades
faker124824591faker
farer86733141farer
lader65633721lader
wader95325371wader
adder75419592adder
after85719792after
ager55935842_ager
aider65431142aider
alder65421912alder
aper66336232_aper
aver75931882_aver
badder103817512badder
bade75140892bade_
badger105415082badger
baker115629542baker
balder95318862balder
baler75635282baler
bander93928222bander
barer74535802barer
baser74828922baser
beader94623792beader
bider85728382bider
blader93618582blader
caber95126832caber
cade76443922cade_
cades85440732cades
cadet85339342cadet
cadger105013912cadger
cadre85419022cadre
cager85229222cager
caner75334772caner
caper94831622caper
carder94524182carder
carer74942332carer
cater74840722cater
caver105629062caver
ceder85322242ceder
cider84723322cider
coder86134222coder
cyder114611132cyder
dander811222992dander
darer65230792darer
dater65332312dater
deader84220472deader
eager65526972eager
eater54639842eater
eider64624752eider
elder64020022elder
ender64325862ender
evader1036812evader
fabber134814112fabber
fabler116115812fabler
face96140122face_
faced117727652faced
facers115519442facers
faces106439432faces
facet106038522facet
fad77452422fad__
faddier1237782faddier
faddy135511622faddy
fadein1068842fadein
fadge104817002fadge
fadged124712362fadged
fadges114814032fadges
fado87226472fad_o
fados95620732fados
fads86939882fad_s
faery116015482fa_ery
fainer94717242fainer
fair76332522fa_ir
fairer95212062fairer
fake115534942fake_
faked135225482faked
fakeer13378742fakeer
fakers134219532fakers
fakery16509262fakery
fakes126032482fakes
fakey155515422fakey
fakir125111492fakir
faller94621232faller
falser93912412falser
falter94519052falter
fame95639392fame_
famed115928342famed
fames105735922fames
fane75343572fane_
fanes84639892fanes
fanner94218182fanner
faqir17548642faqir
far67762602fa__r
farcer115016082farcer
farded114518952farded
fardel104712592fardel
fare76354462fare_
fared95842342fared
farers95924052farers
fares85852872fares
farmer115017372farmer
faster94625772faster
fate75444282fate_
fated95632132fated
fates85139232fates
father125116712father
fatter94523212fatter
fave105532962fave_
faves115331422faves
favor114712452favor
fawner125910462fawner
faxed166220532faxed
faxes155726652faxes
fayed126422152fayed
faze165630042faze_
fazed186222962fazed
fazes175527212fazes
fearer94820182fearer
feater95224052feater
fedex1699602fedex
feeder103513842feeder
fender103718722fender
fer66646122f__er
fever115617952fever
fewer115216122fewer
feyer115014522feyer
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finder104020232finder
finer85431562finer
firer811229252firer
fiver116024942fiver
fixer154717832fixer
flaker134916172flaker
flamer114919122flamer
flayer124713562flayer
fleer86020772fleer
flier86023402flier
flyer114916252flyer
foamer114714312foamer
fodder114712112fodder
folder104317542folder
fonder104120062fonder
foyer116416552foyer
framer114817442framer
frater94520592frater
freer86021242freer
frier85225842frier
fryer115913432fryer
fumer105918232fumer
funder104016092funder
gadder93714712gadder
gager74726292gager
gamer84928942gamer
gander84322762gander
gaper86125122gaper
gater64533652gater
gayer94519192gayer
gazer155720072gazer
grader84919692grader
hade85440202hade_
haded105227622haded
hades96035112hades
haler85033532haler
hander104526432hander
harder105022402harder
hater85034752hater
haver115124462haver
hayer114620242hayer
hazer174820232hazer
header104422542header
heder95623642heder
hider95024092hider
jade125325452jade_
jaded144417032jaded
jades135222112jades
jager134318132jager
japer146218882japer
lacer75833752lacer
ladder84617622ladder
lade56345992lade_
laded74232612laded
laden65022192laden
laders74927762laders
lades65141272lades
ladler74314932ladler
lager65132862lager
laker95432872laker
lamer75233702lamer
lander74028492lander
larder73720972larder
laser54633322laser
later54843922later
lauder73815012lauder
laver85031792laver
laxer125420332laxer
layer84626472layer
leader74824652leader
loader74316312loader
macer912126942macer
madder103515592madder
made75440252made_
madre85720172madre
maker114127812maker
maser75029972maser
mater74438862mater
mazer165722422mazer
nadir61012972nadir
namer75622102namer
nuder66416832nuder
oater55433732oater
odder74515392odder
older65121172older
order65019362order
pacer96131612pacer
padder103415492padder
padre86018162padre
pager84728202pager
paler75436942paler
pander93725532pander
paper95128662paper
parer75839902parer
pater74740732pater
paver104225832paver
pawer104422972pawer
payer105125722payer
racer75233022racer
radar61316722radar
raider74318742raider
raker94529792raker
raper74932752raper
rarer54731702rarer
raser55633412raser
rater54943282rater
raver85631492raver
rawer84623732rawer
razer144824272razer
reader73628292reader
rider65231312rider
ruder65320542ruder
saber75330242saber
sadder82916972sadder
sade55544482sade_
sades65239892sades
safer84721812safer
sager65432052sager
saker95132022saker
sander74828532sander
saner54334322saner
saver84831252saver
sawer85026212sawer
sayer84926552sayer
seder64826762seder
shader104218762shader
spader94317132spader
taber73825822taber
taker95229002taker
taler56034872taler
tamer75230102tamer
taper74829772taper
tater54138612tater
tawer85223442tawer
taxer125019362taxer
trader75218762trader
udder76314282udder
under64624222under
wadder114215482wadder
wade85237072wade_
waded106024752waded
waders109120652waders
wades95634142wades
wafer114417652wafer
wager95925062wager
waker125526602waker
waler84229292waler
wander104423712wander
warder104020272warder
water84733322water
waver115025712waver
waxer154317492waxer
wider94826362wider
yager95616752yager
yarder103813972yarder
yarer84321572yarer
zander163417112zander

Search took 4 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.310576422.6
2DLD Change Limit538002892.79619241.8
3Display Results2892890.0803612.5
 (SQL Overall)1786912893.18656086.3
 
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.