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

346 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
exalter143756(None) 
exacter1637401exacter
exalted1537391exalted
exalters1536651exalters
alter54828502__alter
desalter938362desalter
easter65027982e_aster
eater54639842e_a_ter
elater64724202ela_ter
exacted1737302exacted
exacters1736772exacters
exactor1636622exactor
exalt123018532exalt__
exalts13328312exalt_s
exapted1736072exapted
exciter1637752exciter
exiler134712182exil_er
exulted1536302exulted
falter94519052_falter
halter94420882_halter
palter84423262_palter
psalter9247812psalter
realter73716312realter
salter64325082_salter
abater85518123aba_ter
adapter1036173adapter
after85719793__after
alder65421913__alder
altar55520643__altar
alters64924223__alters
apter76120203__apter
aster55434893__aster
awaiter1057443awaiter
baiter84422553_baiter
balder95318863_balder
baler75635273_bal_er
balker124519163_balker
baller83825203_baller
banter84825333_banter
barter85525373_barter
baster85333593_baster
batter84928873_batter
beater84729393bea_ter
belter84720963_belter
betatter1035453betatter
blaster94017303blaster
blatter94415653blatter
boaster94616433boaster
boater84622093boa_ter
bolter83920753_bolter
calker124917083_calker
caller85125483_caller
calmer105216933_calmer
canter85230113_canter
carter84932273_carter
caster85232573_caster
cater74840703_ca_ter
chanter123919733chanter
chapter144213853chapter
charter123918303charter
chaster124718503chaster
chatter124416643chatter
clatter94014973clatter
coaler84121703coal_er
coalier93416173coalier
coaster94219033coaster
coater84329553coa_ter
colter84625093_colter
coulter94115593coulter
crafter124111333crafter
crater85026633cra_ter
dafter104813343_dafter
darter75320363_darter
dater65332313_da_ter
dealer74122143deal_er
debater104114693deba_ter
decaliter1247983decaliter
decanter112510793decanter
defaulter1343133defaulter
deflater123211603deflater
dekaliter1445063dekaliter
desalted1038313desalted
desalters1037673desalters
dewater112912423dewa_ter
dexter143810893dex__ter
dialer74315433dial_er
dialler848813dialler
diaster82813313diaster
dilater83515643dilater
drafter11449423drafter
eager65526963e_a_ger
earlier72612743earlier
earner63617223e_arner
easier64218463e_asier
eastern74412533e_astern
easters75125683e_asters
eaten55323053e_a_ten
eaters65535943e_a_ters
eatery95316353e_a_tery
ecarte84313503ecarte_
ecartes94212563ecartes
eelier64216463e_elier
egalite8311563egalite_
egalites9310503egalites
eglatere945143eglatere
elate55335883ela_te_
elated74725823ela_ted
elaters74420183ela_ters
elates65032363ela_tes
elder64020023e__lder
elver85216243e__lver
embalmer1444063embalmer
emitter93211083emitter
emoter85415193e_moter
empaler11288353empal_er
enabler9299363enabler
enacted10310643enacted
enactor938033enactor
enate54428143ena_te_
enates64026423ena_tes
enter54726383e__nter
eraser64216333era_ser
erecter93113393erecter
espalier1036363espalier
ester54727713e__ster
evader1036813eva_der
eviler94811893evil_er
eviller1056673eviller
evolver13275803evolver
exabyte1943523exabyte_
exabytes2043613exabytes
exact143516933exact__
exacta15337393exact_a
exactas16336433exactas
exactest1745453exactest
exactly1953823exactly
exactors1737013exactors
exacts15359613exact_s
exaltedly2042313exaltedly
exalting1638033exalting
examen1538283exa_men
examiner17145463examiner
exanthem2043113exanthem
excimer1834963excimer
excite15310883excite_
excited1737853excited
exciters1736323exciters
excites16310633excites
excitor1645993excitor
excluder1843453excluder
excreter1766123excreter
excuser1635813excuser
executer1745313executer
exerted152210053exerted
exhale1636873exhal_e_
exhaled1835283exhal_ed
exhales1737143exhal_es
exhauster1942683exhauster
exhorter1845353exhorter
exhumer1943463exhumer
exile126117653exil_e_
exiled144712463exil_ed
exilers14419733exil_ers
exiles134816403exil_es
existed1538473existed
exited144712523ex_ited
expander18145803expander
expecter1936513expecter
expeller17105783expeller
expirer1635993expirer
exploder1844843exploder
exploiter1844583exploiter
explore1646613explore
explorer1744713explorer
exporter1737363exporter
exposer1637413exposer
extern1348473ex__tern
extoller1564173extoller
extorter1546513extorter
exult122814123exult__
exults13257633exult_s
faller94621233_faller
falser93912413_falser
falters103916473_falters
faster94625773_faster
fatter94523213_fatter
feaster10812983feaster
feater95224053fea_ter
filter94517633_filter
flatter103815963flatter
frater94520593fra_ter
gaiter73819503_gaiter
garter74420513_garter
gaster75027353_gaster
gater64533643_ga_ter
grafter114211153grafter
granter84117133granter
grater74625433gra_ter
hafter124815883_hafter
haler85033523_hal_er
halted105019603_halted
haltere103614703_haltere
halters104619803_halters
hater85034753_ha_ter
hatter94724873_hatter
healer94221803heal_er
heater94828303hea_ter
hexameter2144853hexameter
irater65218343ira_ter
jilter133512513_jilter
jolter133513093_jolter
kelter103214373_kelter
kilter103714343_kilter
krater104014313kra_ter
laster64830633_laster
later54843923_la_ter
latter65027893_latter
levanter1145303levanter
malted94819853_malted
maltier93015483_maltier
master84831343_master
mater74438863_ma_ter
matter84325343_matter
mealier93015903mealier
melter83520113_melter
milter84921233_milter
misalter1038343misalter
molter84119423_molter
moulter93812423moulter
natter64420743_natter
neater64424313nea_ter
negater83711953nega_ter
oater55433733_oa_ter
oxalate1457623oxalate_
oxalated1695323oxalated
oxalates1557063oxalates
oxter123414093ox__ter
paler75436933_pal_er
palier85023563_palier
palmer105816543_palmer
palters94021683_palters
paster85734373_paster
pater74740723_pa_ter
patter84628263_patter
pearter9412743pearter
pedaler103410693pedal_er
pedalfer1443273pedalfer
pedalier1137603pedalier
pedaller1136083pedaller
pelter83321623_pelter
phatter123810203phatter
philter12108213philter
piaster93012883piaster
plaiter93615393plaiter
planter94017803planter
plaster93318693plaster
plater84427693pla_ter
platter93917413platter
poulter93712013poulter
prater84825353pra_ter
prealter1048863prealter
psalters10227713psalters
psaltery13224733psaltery
quarter163211853quarter
quilter16279803quilter
rafter94517583_rafter
ranter63826823_ranter
raster64731443_raster
rater54943283_ra_ter
ratter64326313_ratter
realer63528593real_er
realters83614043realters
realtor73611353realtor
rebater93517903reba_ter
recaller1039313recaller
recanter101913153recanter
refilter1137153refilter
regaler83814623regal_er
relater73723143rela_ter
remaster10311473remaster
revolter11279363revolter
roaster74116663roaster
salted74121203_salted
saltern74010653_saltern
salters73622253_salters
saltier74318633_saltier
saluter73512453_saluter
salver94617753_salver
scaler84321603scal_er
scalier94316913scalier
scalper113912923scalper
scanter94215183scanter
scatter93815173scatter
sealer63928963seal_er
seater64534153sea_ter
sedater83713623seda_ter
shalier103116423shalier
shatter103615693shatter
shelter103214953shelter
skater105015483ska_ter
skelter113610003skelter
slater64429183sla_ter
smaller93410333smaller
smarter94113133smarter
smatter93613333smatter
smelter93311913smelter
spaller92713473spaller
spatter94016523spatter
spelter94113703spelter
staler64025823stal_er
stalker113912253stalker
starter73817873starter
stater64427553sta_ter
svelter10359673svelter
swatter104113323swatter
swelter103711173swelter
taler56034863_tal_er
talker103916223_talker
taller63721963_taller
tarter64023563_tarter
taster64930573_taster
tater54138613_ta_ter
tatter64024573_tatter
tauter64318023_tauter
thaler94613103thal_er
tilter63417693_tilter
toaster74414463toaster
unexalted1744333unexalted
valuer93911443_valuer
vaster94521023_vaster
vaulter10257713vaulter
vealer94016543veal_er
vealier102712173vealier
wafter124114613_wafter
waiter94321253_waiter
waler84229263_wal_er
walker133913993_walker
waltzer1934383_waltzer
wanter94423053_wanter
waster95228943_waster
water84733313_wa_ter
watter93221983_watter
welter93417383_welter
whaler124611973whal_er
xyster16366803_xyster
yatter94116213_yatter

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273467.53317792.0
3Display Results3463460.1562217.9
 (SQL Overall)1786913467.84522777.7
 
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.