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

109 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
splashy154355(None) 
plashy14448871_plashy
splash1168821splash_
flashy15498172_flashy
plash104616562_plash_
plushy14406972_plushy
slash84719682s_lash_
sloshy12366622s_loshy
slushy12417222s_lushy
splashed1435592splashed
splasher1335662splasher
splashes1337502splashes
splashily1742962splashily
splay105816042spla__y
splosh1186542splosh_
squashy2233842squashy
apathy1437033ap_athy
aplasia92510803aplasia
ashy107717353___ashy
blasty115611053_blasty
bolshy1444883bol_shy
brashy145210593_brashy
calash11312433calash_
clash106219033_clash_
classy11379043_classy
dashy125612383__dashy
flash115716213_flash_
fleshy15406283_fleshy
glassy10527753_glassy
lash76539653__lash_
lathy115215063__lathy
mashy136016503__mashy
palsy105417463_pals_y
pash95638133_p_ash_
pasha105417183_p_asha
pasty105725053_p_asty
peachy164510843_peachy
plaguy12386413_plaguy
plashed133712643_plashed
plasher124215033_plasher
plashes124417393_plashes
plasm94114633_plas_m
plasma103810913_plasma
plasms103711333_plasms
platy105021663_pla_ty
play95928983_pla__y
plisky1533713_plisky
plush105614713_plush_
plushly15385383_plushly
poachy16388963_poachy
pushy134614353_p_ushy
salably121610743salably
salary9515213sala_ry
sash77235303s__ash_
sashay1238363s__ashay
sassy85813813s__assy
selah8319613sela_h_
selahs9313213sela_hs
slaggy11438793s_laggy
slangy105411393s_langy
slanty95114843s_lanty
slashed114114853s_lashed
slasher104515333s_lasher
slashes103619103s_lashes
slatey95417063s_latey
slaty86523153s_la_ty
slavey124011803s_lavey
slay76436383s_la__y
slosh84514483s_losh_
slush85316573s_lush_
smash104814433s_mash_
snash84815673s_nash_
spacey136212533sp_acey
spacy125415623sp_a_cy
spahi10311143sp_a_hi
sparky154511523sp_arky
sparry115111303sp_arry
spas67036723sp_as__
spasm94514173sp_as_m
spasms10418973sp_asms
spathe115115693sp_athe
spay96631663sp_a__y
spinachy1842793spinachy
splake1259783spla_ke
splakes1349673splakes
splashers1445283splashers
splashier1443593splashier
splashing1535703splashing
splat76129343spla__t
splats84817303spla_ts
splayed13357813splayed
splays114910873spla_ys
spleeny1234563spleeny
sploshed1434323sploshed
sploshes1336133sploshes
splotchy1841793splotchy
splurgy1343023splurgy
sprawly15166043sprawly
spray106720063spra__y
squash1846833squash_
squishy2244023squishy
stash84916973s_tash_
swash116316753s_wash_
swishy15365843s_wishy
sylphy1744153syl_phy
trashy12509053_trashy
unflashy1741863unflashy
unlash938793unlash_
washy145911843__washy

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271097.06318975.9
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.51523777.9
 
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.