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

146 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
splashers144528(None) 
plashers133813451_plashers
slashers113313611s_lashers
splasher1335661splasher_
splashes1337501splashe_s
clashers134213992_clashers
flashers143912652_flashers
lashers104121832__lashers
plasher124215032_plasher_
plashes124417392_plashe_s
plasters103518132_plasters
slasher104515332s_lasher_
slashes103619102s_lashe_s
slathers113914782s_lathers
smashers13339592s_mashers
splashed1435592splashe_d
splashier1443592splashier_
splatters11327542splatters
sploshes1336132sploshe_s
squashers21184982squashers
swashers14389532s_washers
bashers124820833__bashers
blasters104116143_blasters
blathers134713793_blathers
blushers133911293_blushers
calashes13310533calashe_s
clasher124615513_clasher_
clashes124017283_clashe_s
claspers124410913_claspers
classers104111833_classers
crashers134013233_crashers
dashers115016863__dashers
feldshers1643093feldshers
flasher133914063_flasher_
flashes133916103_flashe_s
fleshers14339443_fleshers
flushers14279733_flushers
kashers143914023__kashers
lasers64925703__las_ers
lasher94824533__lasher_
lashes94831003__lashe_s
lasters75627693__lasters
lathers104321883__lathers
mashers124621053__mashers
pashes115828393_p_ashe_s
passers94717753_p_assers
pasters94531733_p_asters
peachers153213843_peachers
piasters102912813_piasters
pilasters1138223pilasters
pishers123815753_p_ishers
placers114515263_pla_cers
plaguers11286503_plaguers
plaisters1137813_plaisters
plaiters103512633_plaiters
planers94517943_pla_ners
planishers1584773_planishers
planners10399933_planners
planters102915323_planters
plashed133712643_plashe_d
plashier1337613_plashier_
plaster93318693_plaster_
plastery13279703_plastery
platers93924093_pla_ters
platters103415283_platters
players124313763_pla_yers
pleasers104010293_pleas_ers
pleathers1446453_pleathers
plusher124010383_plusher_
plushes124313673_plushe_s
poachers152910763_poachers
polishers1477603polishers
pushers123814503_p_ushers
quashers20186803_quashers
rashers104020913__rashers
replasters1245533replasters
sashes94728483s__ashe_s
sclaffers17122523sclaffers
sheathers1557553sheathers
shushers14267053s_hushers
slabbers123610123s_labbers
slackers143812743s_lackers
slakers114115753s_la_kers
slammers123511223s_lammers
slanders94014013s_landers
slappers123710943s_lappers
slashed114114853s_lashe_d
slaters73123733s_la_ters
slather103816073s_lather_
slavers103716503s_la_vers
slayers104513323s_la_yers
slithers114212953s_lithers
sloshes103811803s_loshe_s
slushes103514413s_lushe_s
smasher123911023s_masher_
smashes123914613s_mashe_s
snashes105214753s_nashe_s
solacers10268893sola_cers
solanders1036963solanders
spacers113813873sp_a_cers
spaders104214473sp_a_ders
spahees1238263sp_a_hees
spallers102910733sp_allers
spammers14378693sp_ammers
spankers14369863sp_ankers
spanners103710773sp_anners
sparers94519613sp_a_rers
spargers11389733sp_argers
sparkers144111313sp_arkers
spathes125116533sp_athe_s
spatters103914703sp_atters
spawners13396493sp_awners
speakers14299453spea_kers
spearers103711143spea_rers
spinsters1136613spinsters
splakes1349673spla_ke_s
splash1168823splash___
splashiest1544463splashiest
splashily1742963splashily
splashiness1642543splashiness
splashing1535703splashing
splashy1543553splash__y
splatter10348883splatter_
splicers12338113spl_icers
splinters11277923splinters
splitters11307323splitters
sploshed1434323sploshe_d
splurgers1253073splurgers
splutters11286273splutters
sprawlers1433903sprawlers
sprayers13367053spra_yers
spymasters1742803spymasters
squasher20185783squasher_
squashes20207803squashe_s
stashes103916173s_tashe_s
swasher134011513s_washer_
swashes134714403s_washe_s
swathers144512083s_wathers
swishers14328053s_wishers
thrashers1565313thrashers
trashers113013643_trashers
unlashes11238043unlashe_s
upgathers1582533upgathers
uplanders1234853uplanders
washers134517523__washers
welshers14246813wel_shers

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.453394461.4
2DLD Change Limit1486411467.17320722.3
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.68923239.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.