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

126 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
psaltery1322473(None) 
psalter9247811psalter_
psalters10227711psalters
psaltry12213801psalt_ry
palter84423262p_alter_
palters94021682p_alters
paltry114910402p_alt_ry
plastery13279702plastery
psalteria1144002psalteria
salter64325082_salter_
saltern74010652_saltern
salters73622252_salters
adultery1244223adultery
alter54828503__alter_
alters64924223__alters
artery9911453__artery
battery124911813_battery
cattery123811603_cattery
cautery12349593_cautery
chattery16357273chattery
clattery13378193clattery
desalter938363desalter_
desalters1037673desalters
drysaltery1751263drysaltery
eatery95316353_ea_tery
exalter1437563exalter_
exalters1536653exalters
falter94519053_falter_
falters103916473_falters
flattery14338293flattery
gallery11468743_gallery
halter94420883_halter_
haltere103614713_haltere
halters104619803_halters
mastery124214323_mastery
mattery123810713_mattery
misalter1038343misalter_
misalters1136913misalters
palely11311933p_al_ely
paler75436933p_al_er_
palfrey1533343p_alfrey
palier85023563p_alier_
palmary14338553p_almary
palmer105816543p_almer_
palmers113513623p_almers
paltered113012493p_altered
palterer102411283p_alterer
pantry115014103p_ant_ry
papery134812743p_a_pery
paster85734373p_aster_
pastern94415063p_astern
pasters94531733p_asters
pastry114913033p_ast_ry
pater74740723p_a_ter_
paters84935833p_a_ters
patter84628263p_atter_
pattern93712053p_attern
patters94825193p_atters
pearter9412743pearter_
pedlery13297083pedl_ery
pelter83321623p_elter_
pelters93720313p_elters
peltry11288653p_elt_ry
phatter123810203phatter_
philter12108213philter_
philters1398173philters
piaster93012883piaster_
piasters102912813piasters
plaiter93615393plaiter_
plaiters103512633plaiters
planter94017803planter_
planters102915323planters
plaster93318693plaster_
plasters103518133plasters
plater84427693pla_ter_
platers93924093pla_ters
platter93917413platter_
platters103415283platters
pottery123011073p_ottery
poulter93712013poulter_
poulters103911053poulters
poultry1235383poult_ry
prater84825353pra_ter_
praters94921653pra_ters
prealter1048863prealter_
prealters1147773prealters
printery13318433printery
psalmed1234503psalme_d
psalmody1642093psalmody
psalteries1276563psalteries
psalterium1452833psalterium
realter73716313realter_
realters83614043realters
salary9515213_sal_ary
salted74121203_salte_d
salterns8388903_salterns
saltest71916513_saltest
saltier74318633_saltier_
saltiers83411953_saltiers
saltily10310543_saltily
saltire73113043_saltire
salty85524383_salt__y
salutary1145113_salutary
saluter73512453_saluter_
saluters8319863_saluters
salver94617753_salver_
salvers103916003_salvers
santera7311303_santera
santero7311133_santero
sealery104011053seal_ery
silvery13328093_silvery
slater64429183_slater_
slaters73123733_slaters
slatey95417063_slate_y
slavery13407893_slavery
smeltery13274963smeltery
spaller92713473spaller_
spallers102910733spallers
spatter94016523spatter_
spatters103914703spatters
spelter94113703spelter_
spelters103912243spelters
sputtery13366473sputtery
sultry938463_sult_ry
wastery134610993_wastery
watery123914493_wa_tery

Search took 9 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.440406115.9
2DLD Change Limit1461621267.92018454.8
3Display Results1261260.0632000.0
 (SQL Overall)1786911268.42321214.7
 
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.