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

105 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
saltpans103481(None) 
saltpan935301saltpan_
salpas85116922sal_pa_s
salpians1036762salpians
saltant7316772salt_ant
salterns8388902salterns
sampans112411002sa_mpans
scalepans1343822scalepans
sultans72411832sult_ans
alans55636173_al__ans
altars64518153_alt_ars
atmans84413963_a_tmans
caftans12179443caft_ans
callans94518473cal_lans
calpacs133110343cal_pacs
calpains1239763cal_pains
caltraps12327253caltraps
captans111612053capt_ans
claypans1543873claypans
dalapons1145443dalapons
daltons8310403dalt_ons
dustpans1143233dustpans
hardpans1436453hardpans
hatpins123410643ha_tpins
jalapins1745623jalapins
japans1539823ja__pans
kaftans14185353kaft_ans
kalians11310183kal_ians
kalpacs15327133kal_pacs
kalpaks12366163kal_paks
kalpas124112943kal_pa_s
lallans74113533lal_lans
malthas1237913maltha_s
martians103111613martians
palapas11311493palapa_s
partans94418283part_ans
pattypans1641753pattypans
platans93413123plat_ans
ratans63819373ra_t_ans
rattans73411953ra_ttans
salaams997703sal_aams
saladang1043843saladang
saladangs1142913saladangs
salads75316963sal__ads
salals65120083sal__als
saleps85014903salep__s
salicins10310933salicins
salinas73116093salina_s
salivas10309603saliva_s
salmons93713263sal_mons
salons63823693sal__ons
saloons74415323sal_oons
salpa75018353sal_pa__
salpae84614273sal_pa_e
salpian938493salpian_
salpids1038193sal_pids
salpinx1636093sal_pinx
salps74423243sal_p__s
salsas65316133sal_sa_s
saltern74010653saltern_
salters73622253salt_ers
saltiers83411953saltiers
salties73725773salt_ies
saltine75018563salt_ine
saltines82917793saltines
salting84120793salt_ing
saltings92811253saltings
saltires83112433saltires
saltless8259343saltless
saltness82610243saltness
salts55431883salt___s
salvias10279933salvia_s
sampan102511893sa_mpan_
sarans64224433sa__rans
satang75711563sa_t_ang
satangs8479713sa_t_angs
satays94411683sa_t_ays
sateens73710753sa_teens
satins64930483sa_t_ins
satraps95011643sa_traps
saucepans1342173saucepans
saurians837763saurians
scalepan1244513scalepan_
seitans73312303seit_ans
sextans14349263sext_ans
shaitans1136413shait_ans
sialidans1042973sialidans
silvans10308333sil_vans
slogans8407983s_logans
solans64122493sol__ans
soldans83210403sol_dans
spans74528733s___pans
stewpans1343713stewpans
suldans8299723sul_dans
sultan63012593sult_an_
sultana7257803sult_ana
sultanas8237153sult_anas
suntans72111733sunt_ans
swanpans1343423swanpans
sylvans13235893syl_vans
taipans9269553ta_ipans
tampans113310983ta_mpans
tarpans92513533ta_rpans
tartans72615823tart_ans
xanthans1845693xanthans

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.563317390.8
2DLD Change Limit1461621056.79621507.1
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.40524131.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.