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

154 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
splashing153570(None) 
plashing143311061_plashing
slashing123713411s_lashing
sploshing1544291sploshing
clashing143812192_clashing
flashing153711552_flashing
lashing114422892__lashing
pashing135120512_p_ashing
sashing114621472s__ashing
slashings13316202s_lashings
sloshing12258822s_loshing
slushing12299642s_lushing
smashing143310242s_mashing
spasming13227202sp_asming
splashier1443592splashier
splashily1742962splashily
splatting1235982splatting
splaying14219302spla_ying
squashing2234702squashing
stashing123511582s_tashing
swashing15369742s_washing
unlashing1336492unlashing
abashing1466623_abashing
ashing107824093___ashing
bashing135422583__bashing
blasting114013433_blasting
blushing14339333_blushing
cashing135022553__cashing
clasping133310263_clasping
classing113211793_classing
crashing143512633_crashing
dashing125917893__dashing
deashing134210953_deashing
encashing1536443encashing
fashing144918793__fashing
flashings16316663_flashings
fleshing15339303_fleshing
flushing15288833_flushing
gashing125119233__gashing
glassing10329973_glassing
gnashing1336423_gnashing
hashing145020163__hashing
lashings124412253__lashings
lashins103915153__lashins
lasing74727983__las_ing
lasting84725243__lasting
lathing114315693__lathing
leashing123310313_leashing
lushing114316113__lushing
mashing134422243__mashing
palsying1436233_palsying
passing104318423_p_assing
pasting103826553_p_asting
peaching163613643_peaching
phasing133211673_phas_ing
pishing134314373_p_ishing
placing123815283_pla_cing
plaguing1236033_plaguing
plaining113911553_plaining
plaiting113113513_plaiting
planing103418253_pla_ning
planishing1645323_planishing
planking153513013_planking
planning113610223_planning
planting113515383_planting
plashier1337613_plashier
plasmin112410033_plasmin_
plasmins12199413_plasmins
plating103823073_pla_ting
platting114813033_platting
playing133816093_pla_ying
plaything1843853_plaything
pleaching17257083_pleaching
pleasing112611593_pleas_ing
poaching163510833_poaching
polishing1536923polishing
pushing133615453_p_ushing
quashing2137093_quashing
rehashing1647113rehashing
relishing13229183relishing
rewashing1676903rewashing
salaaming1265363salaaming
salarying1336073salarying
sassing84615553s__assing
scathing14269703s_cathing
sclaffing1843363sclaffing
sheathing1636873sheathing
shushing15317743s_hushing
slabbing13287783s_labbing
slacking153914133s_lacking
slagging113711583s_lagging
slaking123717473s_la_king
slamming133310003s_lamming
slanging103413433s_langing
slanting94115093s_lanting
slapping133510843s_lapping
slashingly1743863s_lashingly
slating83724653s_la_ting
slatting94014233s_latting
slaving113514833s_la_ving
slaying113316843s_la_ying
smooshing1534793smooshing
smushing14287453s_mushing
solacing11310133sola_cing
solating9315593sola_ting
spacing123614493sp_a_cing
spading113114383sp_a_ding
spaeing103413543sp_a_eing
spalling113213463sp_alling
spamming15317603sp_amming
spanking153911973sp_anking
spanning113311083sp_anning
sparging122611133sp_arging
sparing104823873sp_a_ring
sparking152812543sp_arking
sparling112714533sp_arling
sparring113112223sp_arring
spatting113111763sp_atting
spawning14296913sp_awning
spaying133014623sp_a_ying
speaking153212493spea_king
speaning113512243spea_ning
spearing113216103spea_ring
splash1168823splash___
splashed1435593splash_ed
splasher1335663splash_er
splashers1445283splashers
splashes1337503splash_es
splashiest1544473splashiest
splashiness1642543splashiness
splashy1543553splash__y
splicing1338963spl_icing
splining11310773spl_ining
splinting1238193splinting
splitting1236563splitting
splodging1433303splodging
splotching1842863splotching
splurging1333623splurging
spousing11198733spous_ing
spraining1248153spraining
sprawling15175123sprawling
spraying14299883spra_ying
squishing2234953squishing
squushing2242943squushing
swathing15248713s_wathing
swishing15277813s_wishing
swooshing1643883swooshing
thrashing1635683thrashing
trashing122613223_trashing
unleashing1444463unleashing
upcasting1434823upcasting
uprushing1544043uprushing
washing145119283__washing
welshing15296523wel_shing

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411547.04621095.8
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.54523683.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.