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

181 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
splasher133565(None) 
plasher124215031_plasher
slasher104515321s_lasher
splashed1435591splashed
splashers1445271splashers
splashes1337501splashes
splashier1443591splashier
clasher124615512_clasher
flasher133914062_flasher
lasher94824532__lasher
plashed133712642_plashed
plashers133813452_plashers
plashes124417392_plashes
plashier1337612_plashier
plaster93318692_plaster
plusher124010382_plusher
slashed114114852s_lashed
slashers113313602s_lashers
slashes103619102s_lashes
slather103816062s_lather
smasher123911012s_masher
splash1168822splash__
splashy1543552splash_y
splatter10348882splatter
sploshed1434322sploshed
sploshes1336132sploshes
squasher20185772squasher
swasher134011502s_washer
basher115123813__basher
blaster94017303_blaster
blather125314203_blather
blusher124113113_blusher
brasher124515233_brasher
calashes13310533calashes
clashed133614013_clashed
clashers134213993_clashers
clashes124017283_clashes
clasper113811863_clasper
classer93614613_classer
crasher124616153_crasher
dasher104318983__dasher
feldsher1543243feldsher
flashed144112183_flashed
flashers143912653_flashers
flashes133916103_flashes
flashier1437103_flashier
flesher133610923_flesher
flusher133012273_flusher
gasher104320373__gasher
kasher134915033__kasher
laser54633323__las_er
lashed105625213__lashed
lashers104121833__lashers
lashes94831003__lashes
laster64830633__laster
lather95124353__lather
lusher93818763__lusher
masher114123203__masher
pashed125923143_p_ashed
pashes115828393_p_ashes
passer84721033_p_asser
paster85734373_p_aster
peacher144216073_peacher
piaster93012883_piaster
pilaster1038163pilaster
pisher114317753_p_isher
placer105117743_pla_cer
plaguer10328273_plaguer
plainer93811983_plainer
plaister1068013_plaister
plaiter93615393_plaiter
planer84122653_pla_ner
planisher1495853_planisher
planner93511623_planner
planter94017803_planter
plash104616563_plash__
plashy14448873_plash_y
plasters103518133_plasters
plastery13279703_plastery
plater84427693_pla_ter
platier93716293_platier
platter93917413_platter
player115215213_pla_yer
pleaser93912343_pleas_er
pleather1356653_pleather
plushes124313673_plushes
plushier1375193_plushier
poacher143912323_poacher
polisher1388073polisher
posher115018163_p_osher
pusher114318283_p_usher
quasher19198623_quasher
rasher95024113__rasher
replaster1136583replaster
sashed105622943s__ashed
sashes94728483s__ashes
sclaffer16112653sclaffer
sheather1458213sheather
shusher13288113s_husher
slabber113311393s_labber
slacker133915293s_lacker
slaker104219273s_la_ker
slammer113913033s_lammer
slander84015443s_lander
slapper113512463s_lapper
slash84719683s_lash__
slater64429183s_la_ter
slathers113914773s_lathers
slatier74016813s_latier
slaver94419613s_la_ver
slayer93916333s_la_yer
slither104112983s_lither
sloshed11329823s_loshed
sloshes103811803s_loshes
sloshier1135283s_loshier
slushed113611243s_lushed
slushes103514413s_lushes
slushier1135983s_lushier
smashed133711223s_mashed
smashers13339583s_mashers
smashes123914613s_mashes
snashes105214753s_nashes
solacer93011103sola_cer
solander948123solander
spacer104917793sp_a_cer
spacier114011633sp_acier
spader94317133sp_a_der
spahee11313443sp_a_hee
spaller92713473sp_aller
spammer133410433sp_ammer
spanker133612353sp_anker
spanner94312563sp_anner
sparer84524963sp_a_rer
sparger103613073sp_arger
sparker133914353sp_arker
sparser94311483sp_arser
spasmed12296993sp_asmed
spathe115115693sp_athe_
spathed134013183sp_athed
spathes125116533sp_athes
spatter94016523sp_atter
spawner12347363sp_awner
speaker133311213spea_ker
spearer93913663spea_rer
spinster1036683spinster
splake1259783spla_ke_
splakes1349673spla_kes
splashiest1544463splashiest
splashily1742963splashily
splashing1535703splashing
splatted11356743splatted
splatters11327543splatters
splayed13357813spla_yed
splicer114710523spl_icer
splinter10329703splinter
splitter10348443splitter
splosh1186543splosh__
splurger1143803splurger
splutter10357443splutter
sprawler1334643sprawler
sprayer12369043spra_yer
spymaster1642583spymaster
squashed21215983squashed
squashers21184973squashers
squashes20207803squashes
squashier2143913squashier
stashed113812483s_tashed
stashes103916163s_tashes
swashed144311363s_washed
swashers14389523s_washers
swashes134714403s_washes
swather134213593s_wather
swisher13369523s_wisher
thrasher1455733thrasher
trasher104416123_trasher
unlashed12289183unlashed
unlashes11238043unlashes
upgather14152753upgather
uplander1145533uplander
washer124720393__washer
welsher13377443wel_sher

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.1701051123.5
2DLD Change Limit1461621818.25317710.2
3Display Results1811810.0762381.6
 (SQL Overall)1786911818.49921024.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.