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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

167 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
salep7702295(None) 
sale44959701sale_
saleps85014901saleps
sales56055591sales
salp64534091sal_p
shlep104914831shlep
ale36572342_ale_
alec66430062_alec
alee46652322_alee
alef76340692_alef
aleph10311392_aleph
ales47067102_ales
alp56641132_al_p
asleep847282asleep
bale66353842bale_
baled85436442baled
baler75635272baler
bales76250082bales
dale55643982dale_
dales66439742dales
gale56347322gale_
galea64722942galea
gales65442482gales
galop84716222galop
hale76052832hale_
haled95335822haled
haler85033522haler
hales85449842hales
jalap143612472jalap
jalop144212602jalop
julep14310532julep
kale86533752kale_
kales95730982kales
kelep116014562kelep
male66052302male_
males75049792males
naled65525052naled
pale66055012pale_
palea75028662palea
paled85538722paled
paler75436932paler
pales75753802pales
palet74650802palet
palp85828572pal_p
rale45050562rale_
rales54947492rales
sabe66140572sabe_
sabed86526812sabed
saber75330242saber
sabes76437462sabes
sable74732162sable_
sables85026692sables
sade55544472sade_
sades65239892sades
sae38365182sa_e_
safe75930952safe_
safer84721812safer
safes85226722safes
sage55044592sage_
sager65432052sager
sages65339062sages
sailed74327762sailed
sailer63526102sailer
sake85244962sake_
saker95132022saker
sakes95540752sakes
sal36462882sal__
salad65321832salad
salal55425702salal
salic73424712salic
sall44544682sal_l
sallet63734542sallet
sally85129712sally
salmi7815862salmi
salol55222142salol
salon55228552salon
saloop84212582saloop
salpa75018352salpa
salps74423242salps
sals46851672sal_s
salsa56718922salsa
salt45758522sal_t
salted74121202salted
salter64325082salter
salts55431882salts
salty85524382salty
salve85022132salve
salved103916422salved
salver94617752salver
salves94221762salves
salvo84415642salvo
same65245642same_
samek114915272samek
samlet84126562samlet
samp85733592sa_mp
sane45954342sane_
saned65636272saned
saner54334322saner
sanes55649072sanes
sap56463232sa__p
saree55044662saree
sate45556102sate_
sated66238532sated
satem76021462satem
sates54949322sates
save75741362save_
saved95127112saved
saver84831252saver
saves85838632saves
sawed95628402sawed
sawer85026212sawer
saxes125229342saxes
sayed96127142sayed
sayer84926552sayer
scale74629142scale_
scaled94822442scaled
scaler84321602scaler
scales84529312scales
scaleup1134482scaleup
scalp95217982scal_p
schlep1347092schlep
sealed74328362sealed
sealer63928962sealer
seep66540342s_eep
shale85332832shale_
shaled105023952shaled
shales94731252shales
shaley123714992shaley
sheep105321522sheep
shlepp13366192shlepp
shleps114710332shleps
silex123417412silex
skelp114211422skelp
skep105219352s_kep
slap66434042s_lap
sled55334372s_led
sleep74920182sleep
slept75728102s_lept
slew76228232s_lew
slip67031732s_lip
slop66533872s_lop
sole46053672sole_
soled65835172soled
solei55624342solei
soles55547922soles
spale74929212spale_
spales84728102spales
stale55637102stale_
staled74728102staled
staler64025822staler
stales65538292stales
steep76020702steep
step67126292s_tep
strep77120852strep
swale85221592swale_
swales93920762swales
sweep104715722sweep
tale46154162tale_
taler56034862taler
tales55451372tales
vale74937342vale_
vales85434262vales
valet84337872valet
wale74546432wale_
waled94330992waled
waler84229262waler
wales86142832wales

Search took 2 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 Filter178691538000.346516448.0
2DLD Change Limit538001671.56034487.2
3Display Results1671670.0503340.0
 (SQL Overall)1786911671.95691355.3
 
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.