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

141 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
sploshed143432(None) 
sloshed11329821s_loshed
splashed1435591splashed
sploshes1336131sploshes
galoshed1334472galoshed
plashed133712642_plashed
slashed114114852s_lashed
sloshes103811802s_loshes
slushed113611242s_lushed
smooshed14185992smooshed
splasher1335662splasher
splashes1337502splashes
splodged1333272splodged
splosh1186542splosh__
splotched1742822splotched
swooshed15174272swooshed
apposed1247853appos_ed
blushed134411753_blushed
caboshed1634393caboshed
clashed133614013_clashed
closed95317963_clos_ed
clothed134010283_clothed
coshed124217543__coshed
flashed144112183_flashed
fleshed143210263_fleshed
flossed11388533_flossed
flushed143310973_flushed
galoshe1135393galoshe_
galoshes1236893galoshes
glossed94410073_glossed
goloshe1134723goloshe_
goloshes1236253goloshes
joshed174610903__joshed
kiboshed1842763kiboshed
kyboshed2141753kyboshed
lashed105625213__lashed
lushed104218723__lushed
milkshed1842943milkshed
moshed124517493__moshed
noshed104413503__noshed
opposed1236123oppos_ed
pashed125923143_p_ashed
pished124817063_p_ished
plasher124215033_plasher
plashes124417393_plashes
plodded1265563_plodded
plonked14348103_plonked
plopped11288773_plopped
plotted104612373_plotted
plotzed19376223_plotzed
ploughed15204303_ploughed
plowed124213203_plo_wed
plowhead1742803_plowhead
ployed124310563_plo_yed
plusher124010383_plusher
plushes124313673_plushes
polished1468433polished
pooched152810083_pooched
poohed123912523_p_oohed
posed85828413_p_os_ed
posher115018163_p_osher
posted93722493_p_osted
prosed94921093_pros_ed
pushed125017463_p_ushed
relished1239433relished
sashed105622943s__ashed
scooched16206683scooched
shushed14348493s_hushed
siloed74615303silo__ed
skoshes14246253s_koshes
slasher104515333s_lasher
slashes103619103s_lashes
slogged104910473s_logged
sloped94216853s_lo_ped
slopped123511443s_lopped
slosh84514483s_losh__
sloshier1135283s_loshier
sloshy12366623s_losh_y
slotted84613883s_lotted
slouched14206743s_louched
sloughed13305583s_loughed
slowed104617073s_lo_wed
slushes103514413s_lushes
smashed133711223s_mashed
smooched16185983smooched
smooshes13206863smooshes
smoothed14236473smoothed
smushed13368233s_mushed
snowshed1534423snowshed
soloed74515743solo__ed
soothed113712743s_oothed
spasmed12296993sp_asmed
spathed134013183sp_athed
splash1168823splash__
splashers1445283splashers
splashier1443593splashier
splashy1543553splash_y
splatted11356743splatted
splayed13357813spl_ayed
spliced124310593spl_iced
splined105013113spl_ined
splinted11369253splinted
splodge1134103splodge_
splodges1234153splodges
splore81611303splo_re_
splores91910953splo_res
sploshing1544293sploshing
splotches1643913splotches
splurged1243923splurged
spoiled104811353sp_oiled
spoked134413893sp_o_ked
sponged1137953sp_onged
spoofed13399103sp_oofed
spooked144510473sp_ooked
spooled104613523sp_ooled
spooned103412443sp_ooned
spoored104411293sp_oored
spored94821793sp_o_red
sported104015433sp_orted
spotted103713143sp_otted
spoused10349653sp_oused
spouted103412263sp_outed
sprouted1136393sprouted
squashed21215983squashed
squished21186393squished
squooshed2241843squooshed
squushed21193703squushed
stashed113812493s_tashed
supposed1345783suppos_ed
swashed144311363s_washed
swished14418843s_wished
swooshes14185123swooshes
toolshed1244213toolshed
unlashed12289183unlashed
uploaded1234533uploaded
uprushed14234473uprushed
uptossed1142933uptossed
welshed14277203wel_shed
whooshed1833453whooshed
woolshed1553923woolshed
wooshed14167403_wooshed

Search took 9 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.440406115.9
2DLD Change Limit1461621417.51619446.8
3Display Results1411410.0463065.2
 (SQL Overall)1786911418.00222330.8
 
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.