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 “answer” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

518 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
answer93689(None) 
answers1037041answers
anger66225872an_ger
angler74017862angler
ansae55720972ansae_
answered1235482answered
answerer1144262answerer
anther93715062anther
antler64615552antler
antsier7410772antsier
asker96418782a_sker
asper75520432a_sper
aster55434892a_ster
avower1236822avower
gnawer10386952gnawer
knower1337072knower
newer85717462_newer
unswear1035002unswear
abaser86414343abaser
abater85518123abater
abider95314463abider
abler75624313a_bler
abuser85413683abuser
achier113914263achier
acuter84412863acuter
adder75419593a_dder
adorer74713443adorer
aerier64823153aerier
aether94213673aether
after85719793a_fter
ager55935843a__ger
agger76420893a_gger
aider65431133a_ider
aimer75926823a_imer
airer54927893a_irer
airier64619363airier
aisle55223193aisle_
aisled74516183aisled
aisles64721143aisles
aiver85725163a_iver
alder65421913a_lder
aliner65621983aliner
almner85710723almner
alter54828503a_lter
amasser9418733amasser
ambeer104511593ambeer
amber94523203a_mber
ambler104916443ambler
ameer75618983a_meer
ampler104313303ampler
amuser84712623amuser
anadem939183anadem
anchor113911973anchor
ane37866943an__e_
anear55420323an_ear
anele55628833anele_
aneled74719273aneled
aneles64626293aneles
anes45255933an__es
anew76623133an__ew
angel65019563an_gel
angers75222543an_gers
angle64528873angle_
angled84219073angled
anglers84014823anglers
angles74426703angles
angrier839023angrier
anile54634463anile_
anime75423203anime_
animes84719593animes
anise55129703anise_
aniseed839403aniseed
anises64826693anises
ankle95220253ankle_
ankled114313473ankled
ankles104818383ankles
anklet105618733anklet
annex12310883an_nex
annoyer1095603annoyer
anode65021033anode_
anodes74418753anodes
anole55330373anole_
anoles64827423anoles
another10289153another
ansa45927773ans__a
ansate64517863ansate
ansated84214003ansated
answerers1243743answerers
answering1345803answering
antae56828293antae_
antbear935063antbear
ante46538903an_te_
anted66328243an_ted
anteed75616113anteed
antes56334323an_tes
anthem113410343anthem
anthers103715203anthers
antiar6317173antiar
antiwar1037963antiwar
antiwear1146123antiwear
antlers74014743antlers
antre55224523antre_
antres65021003antres
anuses66218773anuses
anyway1534803anyway
anywhere1742553anywhere
aper66336233a__per
apse67725383aps_e_
apses76823913aps_es
apter76120203a_pter
archer115016243archer
arguer74510543arguer
arider74717743arider
armer76924443a_rmer
arse46539273ars_e_
arses55733873ars_es
artier63419733artier
artsier768943artsier
asea46327183a_s_ea
ashed97829773a_shed
ashen87818673a_shen
ashes86230613a_shes
ashier94714833ashier
ashler9459973ashler
asked106919313a_sked
askers105915403a_skers
askew12529413a_skew
aspen75216093a_spen
aspers86220313a_spers
assayer1035573assayer
assert64922573a_ssert
asses55629283a_sses
asset55932263a_sset
assumer965363assumer
assure6610773assure
assurer767783assurer
astern64815813a_stern
asters65631603a_sters
astir55517093a_stir
aswarm11107913a_swarm
aswirl935093a_swirl
atoner64817193atoner
auger64922473a_uger
aulder7511453aulder
auspex1574793auspex
austere7312993austere
aver75931883a__ver
avowed1335953avowed
avowers1336333avowers
awe67746623a__we_
awed88436033a__wed
awee76336643a__wee
awes76037553a__wes
axseed1456993axseed
bander93928223ban_der
banger94423633ban_ger
banisher13169183banisher
banister10199973banister
banker124222733ban_ker
banner84421503ban_ner
banshee121212453banshee
banter84825333ban_ter
baser74828923bas_er
basher115123813basher
baster85333593baster
bister84922763bister
blower115316573blower
bosker123813653bosker
bower107328183_bower
brawer114216333brawer
brewer114812543brewer
busher114922203busher
busier85219723busier
busker125517833busker
buster84726493buster
cancer104220923can_cer
candler103516593candler
caner75334773can__er
canister101710853canister
canker124422523can_ker
canner84625983can_ner
cannier94014163cannier
canoer85121073can_oer
canter85230113can_ter
caster85232573caster
causer84117783caus_er
censer84516583cens_er
chawer144314413chawer
chewer145512613chewer
clawer114512783clawer
cosher114819903cosher
cosier84423753cosier
coster84331293coster
cower104531773_cower
crower114117553crower
cusser86016093cusser
dabster1036703dabster
dancer94817613dan_cer
dander811222993dan_der
dandier93714573dandier
dandler94414273dandler
danger83722823dan_ger
dangler96912813dangler
danker114319663dan_ker
danseur833663danseur
dasher104318983dasher
denser74115193dens_er
doser66228563dos_er
dosser74417973dosser
dower95027703_dower
dowser104716083dowser
drawer104711363drawer
duster74919723duster
easier64218463easier
easter65027983easter
ender64325863en_der
endower1138483endower
enserf9310763ens_erf
ensue54013833ensue_
ensued73610483ensued
ensues63313813ensues
ensure63416003ensure
ensurer73011903ensurer
enter54726383en_ter
envier939673envier
esker94412983_esker
ester54727713_ester
ewer77523983__ewer
falser93912413fals_er
fancier123412063fancier
fanner94218183fan_ner
faster94625773faster
fester94723513fester
fewer115216123_fewer
fisher124917143fisher
flower124815503flower
foster94322223foster
fusser94813773fusser
gagster9317633gagster
gander84322763gan_der
ganger83721463gan_ger
gangster10215773gangster
ganister9178993ganister
gasher104320373gasher
gasper94515543gasper
gasser75017773gasser
gassier83812573gassier
gaster75027353gaster
glower105114933glower
gnawed11427833gnawed
gnawers11356383gnawers
grower104614933grower
gusher104115773gusher
hamster12810423hamster
hanaper1237133hanaper
hander104526433han_der
handier113817443handier
handler113516163handler
hanger104023253han_ger
hanker134622093han_ker
hanse85722793hans_e_
hansel95214373hans_el
hanses95022633hans_es
harsher13310363harsher
hawser125910843haws_er
hewer115719933_hewer
hisser94713793hisser
hoser811529763hos_er
hosier94219613hosier
husker134212703husker
inaner62213533inaner
incher114114033incher
infer84215033in_fer
inker94421093in_ker
inkier104013773inkier
inlier63615353inlier
inner54920623in_ner
insaner7310433insaner
insert64325253ins_ert
inset54430863ins_et
insider849733insider
instar6310013instar
instep838193instep
insure63416603insure
insurer73312803insurer
inswept1245733inswept
inter55028493in_ter
issuer646623issuer
jangler153811833jangler
jasper154610383jasper
jester134319153jester
josher164312963josher
juster134617013juster
kaiser103610373kais_er
kasher134915033kasher
kisser104212453kisser
knawe12397883knawe_
knawel13415413knawel
knawes13328393knawes
knifer13598563knifer
knowers1436333knowers
kosher134412973kosher
lamster9109913lamster
lancer84319973lan_cer
lander74028483lan_der
landler84113203landler
lanker104123003lan_ker
lankier113711633lankier
lanner64920593lan_ner
lapser84113143laps_er
laser54633323las_er
lasher94824533lasher
lassoer7379383lassoer
laster64830633laster
lesser63514853lesser
lisper84114433lisper
lister64527253lister
loser54728673los_er
lower85830413_lower
lusher93818763lusher
luster64023673luster
manager103413583manager
manger94325003man_ger
mangier104114063mangier
mangler103215643mangler
manlier92414023manlier
manner84020513man_ner
manpower1544703manpower
manse75528223mans_e_
manses84225513mans_es
manurer938583manurer
maser75029973mas_er
masher114123203masher
masker124416103masker
massier93615223massier
master84831343master
menswear1352173menswear
minster93914323minster
miser75430403mis_er
mister84728563mister
monster93214593monster
mosher114719793mosher
mosser84618273mosser
mower104523453_mower
munster93710523munster
muser76024123mus_er
musher113820573musher
muster84724523muster
nabber104913543nabber
nagger84016123nagger
nailer64119363nailer
naiver94311353naiver
namer75622103_namer
napper103718283napper
nastier74115293nastier
natter64420743natter
nester64124183nester
never86218643_never
newel86114133_newel
ngwee9311073_ngwee
nicer74618293_nicer
niter55028973_niter
nonanswer1242633nonanswer
nosher94616363nosher
nosier63716323nosier
noter55025643_noter
nuder66416833_nuder
onager739663onager
onset54730173ons_et
osier53518013_osier
ouster64223733ouster
oyster94111703oyster
pander93725523pan_der
panier84425503pan_ier
panner84224763pan_ner
pannier93613353pannier
pansies94521983pansies
panther12611443panther
panzer174213233pan_zer
parser84822373pars_er
passer84721033passer
paster85734373paster
pauser84415963paus_er
pawer104422973_pawer
penster92811953penster
pester84827593pester
pisher114317753pisher
pisser84416383pisser
plower114315063plower
poser75128773pos_er
posher115018163posher
poster84129173poster
power105325953_power
prower114218123prower
punster92911103punster
pusher114318283pusher
raiser66620103rais_er
rancher123013633rancher
randier83618473randier
ranger73925523ran_ger
rangier83714353rangier
ranker105021903ran_ker
ransomer1047883ransomer
ranter63826823ran_ter
raser55633413ras_er
rasher95024113rasher
rasper83917323rasper
raster64731443raster
rawer84623733_rawer
renewer10248693renewer
rester63832433rester
rinser64317213rins_er
riser55431053ris_er
risker105414493risker
rosier64221263rosier
roster64329083roster
rower85430493_rower
rusher94019653rusher
sander74828533san_der
sandier84017843sandier
saner54334323san__er
sanger74524563san_ger
sansar63613393sans_ar
sansei63411903sans_ei
sassier73413233sassier
sawer85026213_sawer
seer45547043__seer
ser36752403__s_er
sewer84426213_sewer
shewer124515103shewer
shower124315103shower
sister64421583sister
skewer13519603skewer
slower94016153slower
snarer64620843snarer
snawed104813733snawed
sneer54919953sn_eer
snider74413913snider
sniper84413643sniper
snorer64316763snorer
snowed104613613snowed
snowier1038783snowier
sonsier7711743sonsier
sower85229313_sower
spewer115112143spewer
suer45334033__suer
swear85316853__swear
sweer84918573__sweer
tanager83010943tanager
tangier83013903tangier
tangler83515073tangler
tanker104521123tan_ker
tanner63722283tan_ner
tansies74521243tansies
tapster9299273tapster
tarsier74119253tarsier
taster64930573taster
tawer85223443_tawer
tenser64919433tens_er
tester64227153tester
thawer12489343thawer
tosser64215663tosser
tower85729203_tower
transfer1138423transfer
tusker104212193tusker
tusser64615833tusser
ulster63712103ulster
unawed103914903unawed
under64624213un_der
undoer73113043undoer
uniter64619143uniter
unsawed112911503unsawed
unseen62012623unseen
unset54532433uns_et
unsew83912693uns_ew
unsewed112911023unsewed
unsewn9298393unsewn
unsews9379363unsews
unsex123512633uns_ex
unshed10313773unshed
unsober967623unsober
unsowed112511053unsowed
unstep839223unstep
unsure62815413unsure
unswears1144023unswears
unswept1246013unswept
unswore1039053unswore
unsworn1046843unsworn
unwed94114873un_wed
unwet84423173un_wet
user45023003_us_er
usher84517763_usher
vanisher14167453vanisher
vanner94215843van_ner
vaster94521023vaster
vesper1138083vesper
viewer1237213viewer
vower115220793_vower
waister103812383waister
wander104423713wan_der
wangler113312653wangler
wanier93920683wan_ier
wanker134219973wan_ker
wanner94019623wan_ner
wanter94423053wan_ter
warsler10289893warsler
washer124720393washer
waster95228943waster
wester94222893wester
wiser85522803wis_er
wisher123617063wisher
wowser125110203wowser
xyster16366803xyster
yester93417983yester
zander163417113zan_der
zanier154314713zan_ier
zester153617793zester
zoster153715853zoster

Search took 8 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 Filter1786911127160.283631417.0
2DLD Change Limit1127165186.62317018.9
3Display Results5185180.1563320.5
 (SQL Overall)1786915187.06225303.2
 
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.