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

228 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
stippled134530(None) 
stipple1146621stipple_
stippler1235541stippler
stipples1247021stipples
stipuled1134451stipuled
stoppled1345001stoppled
tippled12358391_tippled
crippled15336792crippled
nippled12307642_nippled
rippled123110272_rippled
shipped153312102shipp_ed
sipped113720632s_ipp_ed
skipped16358412skipp_ed
slipped124711742slipp_ed
snipped123510042snipp_ed
stapled103613702st_apled
steepled1135902steepled
stepped123210052stepp_ed
stickled15298972stickled
stifled113511092sti_fled
stilled83314792sti_lled
stiped94517072sti_p_ed
stipplers1334452stipplers
stipule936722stipule_
stipules1037052stipules
stopped124512202stopp_ed
stopple1156582stopple_
stopples1236952stopples
stripped1357092stripp_ed
suppled1248462s_uppled
swipple1444632swipple_
swipples1534842swipples
tipped114418262_tipp_ed
tipple103411912_tipple_
tippler11348342_tippler
tipples112811252_tipples
toppled12348842_toppled
blipped14377193blipp_ed
chipped174110813chipp_ed
clipped14439833clipp_ed
crimpled15366933crimpled
cripple13378583cripple_
crippler14826713crippler
cripples14298403cripples
dappled1336393_dappled
dimpled132810303_dimpled
dipped123517493_dipp_ed
dripped13408083dripp_ed
estopped1334993estopp_ed
fipple13329063_fipple_
fipples14298653_fipples
flipped15358513flipp_ed
gipped124815903_gipp_ed
grappled14336093grappled
gripped13419343gripp_ed
gripple12416613gripple_
hipped144317693_hipp_ed
hirpled13157143_hirpled
hoppled15338083_hoppled
impled113812513__impled
kipped153114573_kipp_ed
lipped114419543_lipp_ed
mispled12310463_mispled
nipped113615853_nipp_ed
nipple103410373_nipple_
nipples11319663_nipples
pimpled14289193_pimpled
pipped104516543_pipp_ed
poppled11339243_poppled
quipped2175163quipp_ed
rimpled123311423_rimpled
ripped114419013_ripp_ed
ripple103413913_ripple_
rippler113210103_rippler
ripples113513293_ripples
ripplet113412583_ripplet
sailed74327763sai__led
sampled123410793s_ampled
sapped114422013s_app_ed
scrupled1335823scrupled
sepaled10510593s_epaled
shilled113313623shi_lled
shingled13358323shingled
shippen14298863shipp_en
shipper143514043shipp_er
shopped153512213shopp_ed
sickled144713433s_ickled
sidled84215173s_i_dled
simple104315173s_imple_
simpler112910863s_impler
simples113014943s_imples
simplex18256393s_implex
singled93914683s_ingled
siped84927683s_i_p_ed
sipper103920993s_ipp_er
sippet103519393s_ipp_et
sizzled16367883s_izzled
skiffled19244423skiffled
skilled123110863ski_lled
skimped16256223skimp_ed
skipper15339573skipp_er
skippered1843433skippered
skippet15288463skipp_et
skirled12348183ski_rled
slapped123511853slapp_ed
sliped95417063sli_p_ed
slipper113712983slipp_er
slippered1434823slippered
slippier1256543slippier
slopped123511443slopp_ed
smiled93716433smi__led
snapped124611203snapp_ed
sniffled15276443sniffled
sniggled11275743sniggled
sniped94913483sni_p_ed
snipper113911333snipp_er
snippet113310433snipp_et
snippier1255793snippier
sniveled1255463sniveled
soiled73822473soi__led
sopped114819903s_opp_ed
spieled104811883spi_eled
spiled94621993s__piled
spilled103613623spi_lled
spindled12287643spindled
spiraled1137733spiraled
stabled103514953st_abled
staled74728103st__aled
stalled83515693st_alled
stamped124812813stamp_ed
staple84415823st_aple_
stapler93913633st_apler
staples93617213st_aples
startled9208563startled
steeled83513223st_eeled
steeped103412283steep_ed
steeple937323steeple_
steeples1038013steeples
steppe10319873stepp_e_
stepper113010853stepp_er
steppes113110693stepp_es
sticked144114633sti_cked
stickle132410973stickle_
stickler14259573stickler
stickles142512103stickles
stied65723033sti___ed
stiffed14359583sti_ffed
stifle93611903sti_fle_
stifler102911473sti_fler
stifles103013393sti_fles
stile54931573sti__le_
stiles64328773sti__les
stiller73414303sti_ller
stilted83511473sti_lted
stimied10310623sti_mied
stinted82914193sti_nted
stipe76523373sti_p_e_
stipel84412123sti_p_el
stipels9418953stipel_s
stipend10386553sti_pend
stipes84524053sti_p_es
stipites1039653stipites
stippling1475173stippling
stipular1045843stipular
stipulated1345593stipulated
stirpes95011293stirp_es
stirred8359703sti_rred
stitched14148203stitched
stithied1235303stithied
stoled74521593st__oled
stomped124110533stomp_ed
stooled84313893st_ooled
stooped103813833stoop_ed
stoped94721013st_op_ed
stopper113012603stopp_er
stoppered1444473stoppered
strapped1357823strapped
streeled9267873streeled
strickled1665833strickled
striped105214363strip_ed
stripper1247123stripp_er
strolled937823strolled
stropped1367343stropped
stubbled1385073stubbled
stumbled1335623stumbled
stumped124210153stump_ed
styled105613103st__yled
supped114415703s_upp_ed
supple10410203s_upple_
suppler1148433s_uppler
supples11511283s_upples
supplied1345993s_upplied
swapped15429143swapp_ed
swilled113611833swi_lled
swindled13307623swindled
swingled13337433swingled
swiped123811093swi_p_ed
swiple11379233swi_ple_
swiples12339643swi_ples
swirled11308223swi_rled
swiveled1544163swiveled
swizzled2053013swizzled
swopped15437673swopp_ed
tapped113820053_tapp_ed
templed12278563_templed
tickled144313133_tickled
tiled64832943_ti__led
tilled74722953_ti_lled
tingled93712803_tingled
tinkled123910473_tinkled
tipper103918413_tipp_er
tippet103917873_tipp_et
tippier113210543_tippier
tipplers12336353_tipplers
tiptoed1036143_tiptoed
tirled74714363_ti_rled
titled73815003_ti_tled
topped114617723_topp_ed
topple104411323_topple_
topples113111653_topples
tripled104113833_tripled
tripped123911693tripp_ed
tupped114013233_tupp_ed
untipped1335763untipp_ed
whipped18379333whipp_ed
wimpled15338823_wimpled
yipped143613283_yipp_ed
zipped203612983_zipp_ed

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622287.06320694.0
3Display Results2282280.0932451.6
 (SQL Overall)1786912287.57623586.5
 
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.