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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

56 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
psalmist127635(None) 
palmist112814341p_almist
psalmists1344071psalmists
palmiest123212032p_almiest
palmists12268812p_almists
phallist1338992phallist
psalmic1345332psalmi_c
psalming1375472psalming
psalms1045672psalm_s_
salmis8514272_salmis_
alarmist1049123alarmist
alist56136783__al_ist
almost81014433__almost
balmiest124110993_balmiest
calmest11312343_calmest
dialist8517763dial_ist
diallist949553diallist
dualist8614053dual_ist
malmiest123211023_malmiest
oralist7619633oral_ist
palais8420423p_alais_
palest83926223p_al_est
paliest93021613p_aliest
palish114718273p_al_ish
palliest102814643p_alliest
palmier113312173p_almier
palming123914013p_alming
palmister1345053p_almister
palmistry1642983p_almistry
palms94921753p_alm_s_
papist102618753p_a_pist
pessimist1345273pessimist
phallism1545713phallism
phallists1445723phallists
pianist9615103pia_nist
playlist1347573playlist
polemist12412363polemist
pollist9816603p_ollist
poloist91016323p_oloist
psalm949273psalm___
psalmed1234503psalm_ed
psalmody1642093psalmody
psammite1442983psammite
qualmiest2044393qualmiest
qualmish2244013qualmish
realist73225383real_ist
sacrist9315423_sacrist
sadist74221353_sa_dist
salamis9313513_salamis_
salmi7815863_salmi__
saltest71916513_saltest
saltiest83117723_saltiest
saltish10312163_saltish
slalomist1174963slalomist
soloist7915893_soloist
tsarist7712253tsa_rist

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.406440125.6
2DLD Change Limit146162566.84321359.3
3Display Results56560.0163500.0
 (SQL Overall)178691567.26524596.1
 
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.