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

424 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
psalters1022771(None) 
palters94021681p_alters
psalter9247811psalter_
psaltery13224731psaltery
salters73622251_salters
alters64924222__alters
desalters1037672desalters
exalters1536652exalters
falters103916472_falters
halters104619802_halters
misalters1136912misalters
palmers113513622p_almers
palter84423262p_alter_
pasters94531732p_asters
paters84935832p_a_ters
patters94825192p_atters
pelters93720312p_elters
philters1398172philters
piasters102912812piasters
plaiters103512632plaiters
planters102915322planters
plasters103518132plasters
platers93924092pla_ters
platters103415282platters
poulters103911052poulters
praters94921652pra_ters
prealters1147772prealters
psalteria1144002psalteria
psalteries1276562psalteries
psaltry12213802psalt_ry
realters83614042realters
salter64325082_salter_
saltern74010652_saltern
salterns8388902_salterns
saltiers83411952_saltiers
saluters8319862_saluters
salvers103916002_salvers
slaters73123732_slaters
spallers102910732spallers
spatters103914702spatters
spelters103912242spelters
abaters95115203aba_ters
adapters1136103adapters
afters94717073__afters
alders74218423__alders
altars64518153__altars
alter54828503__alter_
ashlers10319583ashl_ers
assaulters1042463assaulters
asters65631603__asters
awaiters1146643awaiters
baiters94619303_baiters
balers85626933_bal_ers
balkers134915723_balkers
ballers94421013_ballers
banters94623113_banters
barters94223033_barters
basaltes10367683basalte_s
basters94930303_basters
batters94626013_batters
beaters94925043bea_ters
belters93819413_belters
blasters104116143blasters
blatters104414093blatters
boasters103915663boasters
boaters93419243boa_ters
bolters94017803_bolters
calkers134414693_calkers
callers94221963_callers
canters94827733_canters
carters95327253_carters
casters94729903_casters
caters85336503_ca_ters
chanters134016743chanters
chapters154012133chapters
charters134115583charters
chatters134213953chatters
clatters103313913clatters
coalers94419353coal_ers
coasters104317333coasters
coaters93525793coa_ters
colters93522443_colters
coulters103614313coulters
crafters13419953crafters
craters95021893cra_ters
darters84017603_darters
daters74827373_da_ters
dealers84118613deal_ers
desalter938363desalter_
dialers83614303dial_ers
diallers957773diallers
diasters92913183diasters
dilaters92513063dilaters
disasters1039153disasters
drafters12338523drafters
drysalters1441853drysalters
easters75125683_easters
eaters65535953_ea_ters
elaters74420193ela_ters
espaliers1144123espaliers
esters64627733es__ters
exacters1736773exacters
exalter1437563exalter_
fallers103917993_fallers
falter94519053_falter_
feasters11511563feasters
filters103816553_filters
flatters113814203flatters
fraters103517213fra_ters
gaiters83516543_gaiters
garters84218233_garters
gasaliers1044513gasaliers
gasters85624293_gasters
gaters74728643_ga_ters
grafters12409193grafters
granters93614143granters
graters85419743gra_ters
hafters134614333_hafters
halers94926913_hal_ers
halter94420883_halter_
haltere103614703_haltere
halteres113414593_halteres
halvers133311423_halvers
haters94930403_ha_ters
hatters104221523_hatters
healers104319463heal_ers
heaters104225223hea_ters
insulters945883insulters
jilters144211963_jilters
jolters143711993_jolters
kelters113813753_kelters
kilters113813603_kilters
kraters114212343kra_ters
lasters75627693_lasters
malteds10377603_malteds
masters94628923_masters
maters85032393_ma_ters
matters94421753_matters
melters93918313_melters
milters93619093_milters
misalter1038343misalter_
molters93816973_molters
moulters103510783moulters
natters73718063_natters
oaters65029793_oa_ters
ostlers72911203ostl_ers
pacers105124543p_a_cers
packers153818893p_ackers
padders113312873p_adders
pagers94423253p_a_gers
painters103013023painters
palates93624933p_alate_s
palavers1337993p_alavers
paler75436933p_al_er_
pales75753803p_al_e_s
palets85122313p_al_ets
palier85023563p_alier_
pallets93919303p_allets
pallors9314363p_allors
palmer105816543p_almer_
paltered113012483p_altered
palterer102411273p_alterer
palterers11249533p_alterers
paltry114910403p_alt_ry
pampers133615933p_ampers
panders103423733p_anders
paniers94717333p_aniers
panners93621273p_anners
panthers13510783p_anthers
panzers184012013p_anzers
papers105125323p_a_pers
parers85530743p_a_rers
parkers133816873p_arkers
parsers94118153p_arsers
partiers103514243p_artiers
partners102711133p_artners
partyers13277763p_artyers
passers94717753p_assers
pastels95215183p_astels
paster85734373p_aster_
pastern94415063p_astern
pasterns104112623p_asterns
pastes85233913p_aste_s
pastless102411203pastless
pastors94119003p_astors
patens84820863p_a_tens
pater74740723p_a_ter_
pates76047893p_a_te_s
pattens95414923p_attens
patter84628263p_atter_
pattern93712053p_attern
patterns10439943p_atterns
patzers184210573p_atzers
paupers114311073p_aupers
pausers94113223p_ausers
pavers115021823p_a_vers
pawers114818783p_a_wers
pawners124311073p_awners
payers114621823p_a_yers
peachers153213843peachers
pearlers1039033pearlers
pearter9412743pearter_
pedalers11239393pedal_ers
pedalfers1542903pedalfers
pedaliers1245183pedaliers
pedallers1244763pedallers
pedlers103013273pedl_ers
peelers93615593peel_ers
pelter83321623p_elter_
pensters103012123pensters
pesters93827093p_esters
peters86624593p__eters
petters93722363p_etters
pewters124113353p_ewters
phatter123810203phatter_
philter12108213philter_
philtres1396513philtres
piaffers16114203piaffers
piaster93012883piaster_
piastres10249303piastres
pilasters1138223pilasters
pilfers1238963p_ilfers
pinasters1136823pinasters
placaters1336473placaters
placers114515263pla_cers
plaguers11286503plaguers
plaisters1137813plaisters
plaiter93615393plaiter_
planers94517943pla_ners
plankters1544583plankters
planners10399933planners
planter94017803planter_
plashers133813453plashers
plaster93318693plaster_
plastery13279703plastery
platens94213983pla_tens
plater84427693pla_ter_
plates85432243pla_te_s
platter93917413platter_
players124313763pla_yers
pleaters103613793pleaters
pliers84715153p__liers
plotters104011553plotters
plyers114912983p__lyers
poachers152910763poachers
pointers103013723pointers
polders103617373p_olders
polers84225643p_ol_ers
pollers93420023p_ollers
pollsters1137173pollsters
polluters1135033polluters
poofters1336923poofters
poolers94217423pool_ers
porters93722703p_orters
posters93928013p_osters
potters94024343p_otters
poulter93712013poulter_
pouters94221873p_outers
powters124015663p_owters
praetors1039833praetors
praisers103410833praisers
prancers123210333prancers
prater84825353pra_ter_
prates84633163pra_te_s
prattlers11195323prattlers
prawners1346003prawners
prayers124212853pra_yers
prealter1048863prealter_
presters103419003presters
printers103214903printers
psalmed1234503psalme_d
psalms1045673psal__ms
psalterium1452833psalterium
psaltries1185743psaltries
pulers83820283p_ul_ers
pullers93618483p_ullers
pulpers114612283p_ulpers
pulsers94213153p_ulsers
punsters103310583punsters
punters93617043p_unters
putters94219193p_utters
quarters173110453quarters
quilters17228433quilters
rafters103715633_rafters
ranters73323643_ranters
rasters74629023_rasters
raters63936583_ra_ters
ratters74422473_ratters
realter73716313realter_
realtors82811683realtors
relaters83218153relaters
roasters83615933roasters
sabers85224733_sa_bers
sackers133820223_sackers
saggers94017083_saggers
sailers73822323_sailers
sakers104125433_sa_kers
saleps85014903_sal_eps
sales56055593_sal_e_s
sallets73719653_sallets
salliers83613343_salliers
salted74121203_salte_d
saltest71916513_saltest
saltier74318633_saltier_
salties73725773_salties
saltire73113033_saltire
saltires83112423_saltires
saltless8259343_saltless
saltness82610243_saltness
salts55431883_salt__s
saluter73512453_saluter_
salutes73716253_salute_s
salver94617753_salver_
salves94221763_salve_s
salvors103910913_salvors
sanders84025943_sanders
sangers84421943_sangers
santera7311303_santera
santeras8311063_santeras
santero7311133_santero
santeros8311193_santeros
santirs7312963_santirs
santurs7310763_santurs
sappers113518903_sappers
sartors7314973_sartors
sates54949323_sa_te_s
satyrs937963_sa_tyrs
saucers93712133_saucers
saugers83914053_saugers
saunters82911753_saunters
sautes63924913_saute_s
savers93825923_sa_vers
sawers94620163_sa_wers
sawyers13317533_sawyers
sayers94221593_sa_yers
scalers93817263scal_ers
scalpers123710863scalpers
scatters103612753scatters
scoters93313813_scoters
sealers74323553seal_ers
seaters74028943_seaters
sellers73721323_sellers
seltzers1735063_seltzers
setters73822063_setters
shatters113313913shatters
shelters113412813shelters
sifters103714793_sifters
sillers73822103_sillers
silvers104714043_silvers
sinters74024083_sinters
sisters73721593_sisters
sitters74221553_sitters
skaters113512963_skaters
skelters12349373skelters
slakers114115753_slakers
slater64429183_slater_
slates64934063_slate_s
slathers113914783_slathers
slavers103716503_slavers
slayers104513323_slayers
smatters104011713smatters
smelters103310513smelters
smiters93414363_smiters
solders83517773_solders
solvers104414253_solvers
sorters74221133_sorters
souters74422603_souters
spacers113813873spa_cers
spaders104214473spa_ders
spales84728103spal_e_s
spaller92713473spaller_
spammers14378693spammers
spankers14369863spankers
spanners103710773spanners
sparers94519613spa_rers
spargers11389733spargers
sparkers144111313sparkers
spates85028173spa_te_s
spatter94016523spatter_
spawners13396493spawners
specters122811063specters
spellers102812763spellers
spelter94113703spelter_
spillers103311703spillers
spitters104113383spitters
splatters11327543splatters
sporters103714063sporters
spotters104313383spotters
spouters104011163spouters
spurters103311703spurters
sputters104012873sputters
stalkers12369853stalkers
starters83714773starters
staters73922343_staters
suiters73618883_suiters
sulkers113613343_sulkers
sutlers73116973_sutlers
swatters113911793swatters
swelters113110193swelters
talers64628143_tal_ers
talkers113513213_talkers
tasters74225643_tasters
taters64932203_ta_ters
tatters74520483_tatters
thalers106212263thal_ers
tilters73315953_tilters
toasters83912723toasters
updaters11255183upda_ters
upsetters1143653upsetters
upstaters11174803upstaters
valuers10328943_valuers
vaulters11206173vaulters
vealers103214293veal_ers
wafters134112813_wafters
waiters104218623_waiters
walers94824463_wal_ers
walkers143411473_walkers
waltzers2034003_waltzers
wanters104420093_wanters
wasters104026593_wasters
waters95030633_wa_ters
welters103516063_welters
whalers13529703whal_ers
yatters103914623_yatters

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 Filter1786911461620.423422437.4
2DLD Change Limit1461624247.29620033.2
3Display Results4244240.1732450.9
 (SQL Overall)1786914247.89222642.0
 
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.