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

521 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
psalter924781(None) 
palter84423261p_alter
psalters10227711psalters
psaltery13224731psaltery
salter64325081_salter
alter54828502__alter
desalter938362desalter
exalter1437562exalter
falter94519052_falter
halter94420882_halter
misalter1038342misalter
paler75436942p_al_er
palier85023572p_alier
palmer105816542p_almer
palters94021682p_alters
paster85734372p_aster
pater74740732p_a_ter
patter84628262p_atter
pearter9412742pearter
pelter83321622p_elter
phatter123810202phatter
philter12108212philter
piaster93012882piaster
plaiter93615392plaiter
planter94017812planter
plaster93318692plaster
plater84427692pla_ter
platter93917412platter
poulter93712012poulter
prater84825352pra_ter
prealter1048862prealter
psalmed1234502psalmed
psalteria1144012psalteria
psaltry12213802psaltry
realter73716312realter
salted74121202_salted
saltern74010652_saltern
salters73622252_salters
saltier74318632_saltier
saluter73512452_saluter
salver94617752_salver
slater64429182_slater
spaller92713472spaller
spatter94016522spatter
spelter94113702spelter
abater85518123aba_ter
adapter1036173adapter
after85719793__after
alder65421913__alder
altar55520643__altar
alters64924223__alters
apter76120203__apter
ashler9459973ashl_er
assaulter942753assaulter
aster55434893__aster
awaiter1057443awaiter
baiter84422563_baiter
balder95318863_balder
baler75635283_bal_er
balker124519163_balker
baller83825203_baller
banter84825343_banter
barter85525383_barter
basaltes10367683basaltes
baster85333603_baster
batter84928883_batter
beater84729393bea_ter
belter84720963_belter
blaster94017303blaster
blatter94415653blatter
boaster94616433boaster
boater84622093boa_ter
bolter83920753_bolter
calker124917083_calker
caller85125483_caller
calmer105216933_calmer
canter85230113_canter
carter84932273_carter
caster85232573_caster
cater74840723_ca_ter
chanter123919733chanter
chapter144213853chapter
charter123918303charter
chaster124718503chaster
chatter124416643chatter
clatter94014973clatter
coaler84121713coal_er
coalier93416183coalier
coaster94219043coaster
coater84329573coa_ter
colter84625093_colter
coulter94115603coulter
crafter124111333crafter
crater85026643cra_ter
dafter104813343_dafter
darter75320363_darter
dater65332313_da_ter
dealer74122143deal_er
desalted1038313desalted
desalters1037673desalters
dialer74315433dial_er
dialler848813dialler
diaster82813313diaster
dilater83515653dilater
disaster949943disaster
drafter11449433drafter
drysalter1341933drysalter
easter65027983_easter
eater54639843_ea_ter
elater64724203ela_ter
espalier1036363espalier
ester54727713es__ter
exacter1637403exacter
exalted1537393exalted
exalters1536653exalters
faller94621233_faller
falser93912413_falser
falters103916473_falters
faster94625773_faster
fatter94523213_fatter
feaster10812983feaster
feater95224053fea_ter
filter94517633_filter
flatter103815963flatter
frater94520593fra_ter
gaiter73819503_gaiter
garter74420513_garter
gasalier936443gasalier
gaster75027353_gaster
gater64533653_ga_ter
grafter114211153grafter
granter84117133granter
grater74625443gra_ter
hafter124815883_hafter
haler85033533_hal_er
halted105019603_halted
haltere103614713_haltere
halters104619803_halters
hater85034753_ha_ter
hatter94724873_hatter
healer94221803heal_er
heater94828303hea_ter
insulter836883insulter
irater65218353ira_ter
jilter133512513_jilter
jolter133513093_jolter
kelter103214383_kelter
kilter103714343_kilter
krater104014313kra_ter
laster64830633_laster
later54843923_la_ter
latter65027893_latter
malted94819863_malted
maltier93015483_maltier
master84831343_master
mater74438863_ma_ter
matter84325343_matter
mealier93015903mealier
melter83520113_melter
milter84921233_milter
misalters1136913misalters
molter84119423_molter
moulter93812423moulter
natter64420743_natter
neater64424313nea_ter
oater55433733_oa_ter
ostler63312193ostl_er
pacer96131613p_a_cer
pacier105018683p_acier
packer144223403p_acker
padder103415493p_adder
pager84728203p_a_ger
painter93814563painter
palate84226793p_alate_
palates93624943p_alates
palaver1238753p_alaver
pale66055013p_al_e_
palea75028663p_al_ea
paled85538723p_al_ed
pales75753803p_al_es
palet74650803p_al_et
palets85122313p_alets
palled94625163p_alled
pallet84232653p_allet
pallier94417173pallier
pallor8313683p_allor
palmar104113473p_almar
palmed114314643p_almed
palmers113513623p_almers
palmier113312183p_almier
palped114513643p_alped
paltered113012503p_altered
palterer102411293p_alterer
paltrier1037543p_altrier
paltry114910403p_altry
pamper124316663p_amper
pander93725533p_ander
panier84425503p_anier
panner84224763p_anner
panted95024823p_anted
panther12611443p_anther
panzer174213233p_anzer
paper95128663p_a_per
parer75839903p_a_rer
parker124121373p_arker
parser84822373p_arser
parted94228683p_arted
partier93520713p_artier
partner92811393p_artner
partyer12337873p_artyer
passer84721033p_asser
paste74932953p_aste_
pasted94426903p_asted
pastel85918713p_astel
pastern94415063p_astern
pasters94531733p_asters
pastes85233913p_astes
pastier94320383pastier
pastor84817483p_astor
pate65350463p_a_te_
pated85237843p_a_ted
paten74827343p_a_ten
paters84935843p_a_ters
pates76047893p_a_tes
patted94724683p_atted
pattee84323383p_attee
patten84418193p_atten
pattern93712053p_attern
patters94825193p_atters
patzer173111643p_atzer
pauper103511943p_auper
pauser84415963p_auser
paver104225833p_a_ver
pawer104422973p_a_wer
pawner114212923p_awner
payer105125723p_a_yer
peacher144216073peacher
peakier134411443peakier
pealed95322813peal_ed
pearler9310373pearler
pearlier1037323pearlier
peatier94017233peatier
pedaler103410693pedal_er
pedalfer1443273pedalfer
pedalier1137603pedalier
pedaller1136093pedaller
pedler93614623pedl_er
peeler83517383peel_er
pelted94617763p_elted
pelters93720313p_elters
penster92811953penster
perter84422283p_erter
pester84827593p_ester
peter74427593p__eter
petter83924773p_etter
pewter114013673p_ewter
philters1398173philters
philtre12105213philtre
piaffer15104443piaffer
piasters102912813piasters
piastre9307893piastre
pilaster1038163pilaster
pilfer1139163p_ilfer
pinaster1037113pinaster
placater1238013placater
placer105117743pla_cer
plaguer10328273plaguer
plainer93811983plainer
plaister1068013plaister
plaited103713893plaited
plaiters103512633plaiters
planer84122663pla_ner
plankter1435363plankter
planner93511633planner
plantar9369993plantar
planted103516123planted
planters102915333planters
plasher124215033plasher
plasters103518133plasters
plastery13279703plastery
plate74635113pla_te_
plated95225773pla_ted
platen84518203pla_ten
platers93924093pla_ters
plates85432243pla_tes
platier93716293platier
platted103614263platted
platters103415283platters
player115215213pla_yer
pleater93916333pleater
plier75221283p__lier
plotter94113663plotter
plyer106214333p__lyer
poacher143912323poacher
pointer93814933pointer
polder94019253p_older
poler74431793p_ol_er
politer92417073politer
poller83921853p_oller
pollster1037103pollster
polluter1035403polluter
poofter1237163poofter
pooler83819843pool_er
porter84224413p_orter
poster84129173p_oster
potter83926983p_otter
poulters103911053poulters
pouter83923983p_outer
powter114116033p_owter
praetor938973praetor
praiser93413943praiser
prancer113613383prancer
prate75135983pra_te_
prated94924923pra_ted
praters94921653pra_ters
prates84633163pra_tes
prattler10166343prattler
prawner1246803prawner
prayer114815293pra_yer
prealters1147773prealters
prester93519623prester
printer93917303printer
psalm949273psal__m
psalmic1345333psalmic
psalms1045673psal_ms
psalteries1276563psalteries
psalterium1452843psalterium
psaltries1185743psaltries
puler74826623p_ul_er
puller83820813p_uller
pulper103513273p_ulper
pulser84215193p_ulser
punster92911103punster
punter84320033p_unter
putter83921443p_utter
quarter163211863quarter
quilter16279803quilter
rafter94517583_rafter
ranter63826823_ranter
raster64731443_raster
rater54943283_ra_ter
ratter64326313_ratter
realer63528593real_er
realters83614043realters
realtor73611353realtor
relater73723143relater
roaster74116663roaster
saber75330243_sa_ber
sacker125124843_sacker
sadder82916973_sadder
safer84721813_sa_fer
sager65432053_sa_ger
sagger84321073_sagger
sagier73717163_sagier
sailer63526103_sailer
saker95132023_sa_ker
sale44959703_sal_e_
salep77022953_sal_ep
sales56055593_sal_es
sallet63734543_sallet
sallier73320433_sallier
salt45758523_salt__
salterns8388903_salterns
saltest71916513_saltest
saltie63422433_saltie
saltiers83411953_saltiers
salties73725773_salties
saltire73113043_saltire
salts55431883_salt_s
salty85524383_salt_y
salute64418023_salute_
saluted84511713_saluted
saluters8319863_saluters
salutes73716253_salutes
salve85022133_salve_
salved103916423_salved
salvers103916003_salvers
salves94221763_salves
salvor94711093_salvor
sander74828533_sander
saner54334323_sa_ner
sanger74524573_sanger
santera7311313_santera
santero7311133_santero
santir6315253_santir
santur6311273_santur
sapper103822353_sapper
sartor6313883_sartor
sate45556103_sa_te_
sated66238533_sa_ted
satem76021463_sa_tem
sates54949323_sa_tes
satyr848483_sa_tyr
saucer84314103_saucer
sauger74316253_sauger
saunter72913453_saunter
saute55028083_saute_
sauted74119603_sauted
sautes63924913_sautes
saver84831253_sa_ver
sawer85026213_sa_wer
sawyer12438043_sawyer
sayer84926553_sa_yer
scaler84321613scal_er
scalier94316913scalier
scalper113912923scalper
scanter94215183scanter
scatter93815173scatter
scoter83815483_scoter
sealer63928963seal_er
seater64534163_seater
seller63824603_seller
seltzer1635213_seltzer
setter64023723_setter
shalier103116423shalier
shatter103615703shatter
shelter103214963shelter
sifter94516233_sifter
siller64026063_siller
silted74020013_silted
siltier73413863_siltier
silver93815813_silver
sinter63625923_sinter
sister64421583_sister
sitter63323383_sitter
skater105015493_skater
skelter113610003skelter
slaker104219273_slaker
slate55438283_slate_
slated75028313_slated
slaters73123733_slaters
slates64934063_slates
slatey95417063_slatey
slather103816083_slather
slatier74016813_slatier
slaver94419613_slaver
slayer93916333_slayer
slier54827243_s_lier
slyer85515123_s_lyer
smaller93410333smaller
smarter94113133smarter
smatter93613333smatter
smelter93311913smelter
smiter83616413_smiter
softer94015313_softer
solder73921343_solder
solver94016703_solver
sorter64425093_sorter
souter64225923_souter
spacer104917793spa_cer
spacier114011633spacier
spader94317133spa_der
spale74929213spal_e_
spales84728103spal_es
spalled103113133spalled
spallers102910733spallers
spammer133410433spammer
spanker133612353spanker
spanner94312563spanner
sparer84524963spa_rer
sparger103613083sparger
sparker133914363sparker
sparser94311483sparser
spate74731583spa_te_
spates85028173spa_tes
spatted104014143spatted
spatters103914703spatters
spawner12347363spawner
specter113111733specter
speller95415153speller
spelters103912243spelters
spiller92914333spiller
spitter94015183spitter
splatter10348883splatter
sporter93616553sporter
spotter94514883spotter
spouter94213223spouter
spurter94013003spurter
sputter94014053sputter
staler64025823stal_er
stalker113912253stalker
starter73817883starter
stater64427563_stater
suiter64121813_suiter
sulker104015923_sulker
sutler63718393_sutler
svelter10359673svelter
swatter104113323swatter
swelter103711173swelter
taler56034873_tal_er
talker103916223_talker
taller63721963_taller
tarter64023563_tarter
taster64930573_taster
tater54138613_ta_ter
tatter64024573_tatter
tauter64318023_tauter
thaler94613103thal_er
tilter63417693_tilter
toaster74414463toaster
unsalted9510923unsalted
updater10347253upda_ter
upsetter1034643upsetter
upstater10156663upstater
valuer93911443_valuer
vaster94521023_vaster
vaulter10257713vaulter
vealer94016543veal_er
vealier102712173vealier
wafter124114613_wafter
waiter94321253_waiter
waler84229293_wal_er
walker133914003_walker
waltzer1934383_waltzer
wanter94423053_wanter
waster95228943_waster
water84733323_wa_ter
watter93221983_watter
welter93417383_welter
whaler124611983whal_er
yatter94116213_yatter

Search took 7 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.390458182.1
2DLD Change Limit1340275216.22021547.7
3Display Results5215210.1902742.1
 (SQL Overall)1786915216.80026278.1
 
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.