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

258 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
salps7442324(None) 
alps65529241_alps
palps94719561palps
saleps85014901saleps
sales56055591sales
salp64534091salp_
salpa75018351salpa
salpas85116921salpas
sals46851671sal_s
salts55431881salts
samps96124671samps
saps65346371sa_ps
scalps104315231scalps
slaps76025711slaps
aals49941142aal_s
alas46358122_alas
albs68628572_albs
ales47067102_ales
alls46740922_alls
alms65834922_alms
alp56641132_alp_
als36663022_al_s
alts46639902_alts
amps86230342_amps
apps86319692_apps
asps65622092_asps
balas76937212balas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042bal_s
baps86040842ba_ps
calfs104919382calfs
calks115421602calks
calls75634732calls
calms95222352calms
calos74431902calos
camps116330262camps
caps87147892ca_ps
carps96932252carps
claps95626182claps
dales66439742dales
dals57145122dal_s
damps105220412damps
daps77239162da_ps
falls85727652falls
flaps105621382flaps
galas65731642galas
gales65442482gales
galls64729322galls
galops94712622galops
gals57946502gal_s
gamps105323712gamps
gaps76042972ga_ps
gasps85415482gasps
gawps115911012gawps
gulps84715072gulps
hales85449842hales
halls85633782halls
halms105225212halms
halos85230252halos
halts85230102halts
haps96443462ha_ps
harps105926872harps
hasps105114642hasps
helps105219342helps
jalaps15299182jalaps
jalops15329592jalops
jaups144810532jaups
kales95730982kales
kalpa114512192kalpa
kalpas124112942kalpas
kelps115116422kelps
lalls55324132lalls
lamps95624832lamps
laps66848872la_ps
males75049792males
malls76233432malls
malms95021552malms
malts76331752malts
maps86141052ma_ps
nalas55528362nalas
naps66238582na_ps
pales75753802pales
palls74332562palls
palms94921752palms
palp85828572palp_
palpi95414552palpi
palpus104210282palpus
pals66951352pal_s
paps86443452pa_ps
psalms1045672psalms
pulps95116482pulps
rales54947492rales
ralph1078742ralph
ralphs1135372ralphs
ramps96224632ramps
raps66247732ra_ps
rasps74316662rasps
sabes76437462sabes
sables85026692sables
sabs66643742sa_bs
sacks114228872sacks
sacs65739072sa_cs
sades65239892sades
sadis64930852sadis
safes85226722safes
sagas66025882sagas
sages65339062sages
sagos66123872sagos
sags55948402sa_gs
saids65328852saids
sails55738102sails
sains55639972sains
sakes95540752sakes
sakis95323672sakis
sal36462882sal__
salad65321832salad
salads75316962salads
salal55425702salal
salals65120082salals
sale44959702sal_e
salep77022952salep
salic73424712salic
sall44544682sal_l
sally85129712sally
salmi7815862salmi
salmis8514272salmis
salol55222142salol
salols64017872salols
salon55228552salon
salons63823692salons
saloops93510132saloops
salpae84614272salpae
salpid9510882salpid
salpids1038192salpids
salsa56718922salsa
salsas65316132salsas
salt45758522sal_t
salty85524382salty
salve85022132salve
salves94221762salves
salvo84415642salvo
salvos94613382salvos
samp85733592samp_
sands65228582sands
sanes55649072sanes
sans45153362sa_ns
sap56463232sa_p_
sappy125413472sappy
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
sass45035622sa_ss
sates54949322sates
satis55633682satis
sauls55128122sauls
saults65816172saults
saves85838632saves
saws75839482sa_ws
saxes125229342saxes
says75942102sa_ys
scalds94813692scalds
scales84529312scales
scalls84218202scalls
scalp95217982scalp_
scamps125014172scamps
scarps104718602scarps
scaups105411932scaups
scops95820192scops
sculps104611752sculps
scups95316652scups
seals54839692seal_s
seeps74828752seeps
selfs85220242selfs
sells55134432sells
sels46345982sel_s
shales94731252shales
sharps115516082sharps
ships105123772ships
shleps114710332shleps
shops104222902shops
sials54227242sial_s
silds65520522silds
silks94620682silks
sills55135992sills
silos56029432silos
silts55330822silts
simps94719762simps
sips65740102s_ips
skalds11437832skalds
skelps12407922skelps
skeps115614252skeps
skips115616602skips
slabs75322642slabs
slags66525902slags
slams74927902slams
slap66434042slap_
slats55436902slats
slaws85222712slaws
slays85723682slays
slips76023722slips
slops75026012slops
smalls84514122smalls
smalts85214892smalts
snaps74719562snaps
snips75818012snips
soaps75120712soaps
soles55547922soles
solos54830792solos
sols45448162sol_s
solus54726982solus
sops65244562s_ops
soups75322942soups
spales84728102spales
spalls84217342spalls
stales65538292stales
stalks104614552stalks
stalls64019932stalls
stamps105614022stamps
steps76619882steps
stops74827282stops
sulks94818462sulks
sulus54821882sulus
sumps95023432sumps
sups64834432s_ups
swales93920762swales
swamps135910262swamps
swaps104819202swaps
swops105913972swops
sylis84316022sylis
sylph1347792sylph
sylphs1435542sylphs
talas55935892talas
talcs74817182talcs
tales55451372tales
talks94322692talks
talls55133432talls
talus55423262talus
tamps95524082tamps
taps66050672ta_ps
tarps76527112tarps
vales85434262vales
vamps125415482vamps
wales86142832wales
walks126218502walks
walls85529382walls
waps96642082wa_ps
warps107126422warps
wasps106714692wasps
yaps95933522ya_ps
yaups105910742yaups
yawps13628792yawps
yelps105712992yelps
zaps156826892za_ps

Search took 3 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.310576422.6
2DLD Change Limit538002581.70631535.8
3Display Results2582580.0604300.0
 (SQL Overall)1786912582.07686074.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.