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

124 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
saltpan93530(None) 
saltpans1034811saltpans
salpa75018352sal_pa_
salpae84614272sal_pae
salpas85116922sal_pas
salpian938492salpian
saltant7316772salt_ant
saltern74010652saltern
sampan102511892sa_mpan
scalepan1244512scalepan
sultan63012592sult_an
alan46844083_al__an
altar55520643_alt_ar
atman75520143_a_tman
batman105214063ba_tman
caftan111710123caft_an
callan83619603cal_lan
calpac123211063cal_pac
calpain11310413cal_pain
caltrap11297943caltrap
captan101613343capt_an
claypan1434313claypan
dalapon1044893dalapon
dalton7311273dalt_on
dustpan1043243dustpan
hardpan1336443hardpan
hatpin112610613ha_tpin
jalapin1645923jalapin
japan14411233ja__pan
kaftan13185823kaft_an
kalian10312163kal_ian
kalpa114512193kal_pa_
kalpac14428223kal_pac
kalpak11437243kal_pak
kalpas124112943kal_pas
lactean956473lactean
lallan63414173lal_lan
maltha1137503maltha_
malthas1237913malthas
martian93514683martian
palapa10310673palapa_
palapas11311493palapas
palpal104112053pal_pal
partan83820563part_an
pattypan1541863pattypan
platan83913693plat_an
ratan53722663ra_t_an
rattan63613603ra_ttan
sagaman10117563sagaman
salaam8711013sal_aam
salad65321833sal__ad
saladang1043843saladang
salal55425703sal__al
salep77022953salep__
saleps85014903salep_s
salesman1047353salesman
salicin9311223salicin
salina64221123salina_
salinas73116093salinas
saliva93110743saliva_
salivas10309603salivas
salmon84614183sal_mon
salon55228553sal__on
saloon64418023sal_oon
salp64534093sal_p__
salpians1036763salpians
salpid9510883sal_pid
salpinx1636093sal_pinx
salps74423243sal_p_s
salsa56718923sal_sa_
salsas65316133sal_sas
salt45758523salt___
saltbox1643743saltbox
salted74121203salt_ed
salter64325083salt_er
salterns8388903salterns
salters73622253salters
saltest71916513saltest
saltie63422433salt_ie
saltier74318633saltier
salties73725773salties
saltily10310543saltily
saltine75018563saltine
salting84120793salting
saltire73113033saltire
saltish10312163saltish
salts55431883salt__s
salty85524383salt__y
salvia93310753salvia_
salvias10279933salvias
sampans112411003sa_mpans
sandman10310173sandman
saran53730303sa__ran
satang75711563sa_t_ang
satay84718463sa_t_ay
sateen63815013sa_teen
satin55935223sa_t_in
satrap86212553sa_trap
saucepan1242533saucepan
saurian739913saurian
scalepans1343823scalepans
seitan62613233seit_an
sextan13389643sext_an
shaitan1036893shait_an
sialidan943823sialidan
silvan92810153sil_van
slogan7539223s_logan
solan55328153sol__an
soldan73511853sol_dan
span65234663s___pan
spartan948333spart_an
stewpan1234193stewpan
suldan72611043sul_dan
sultana7257803sult_ana
sultans72411833sult_ans
suntan62613003sunt_an
swanpan1243693swanpan
sylvan12257363syl_van
taipan82410663ta_ipan
tampan102512323ta_mpan
tarpan82814293ta_rpan
tartan64217513tart_an
ulpan7310123_ul_pan
xanthan1736013xanthan

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.406440125.6
2DLD Change Limit1340271246.22021547.7
3Display Results1241240.0462695.7
 (SQL Overall)1786911246.67226782.2
 
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.