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 “splattered” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
splattered1316393(None) 
spattered12187641sp_attered
spluttered13153171spluttered
blattered12198562_blattered
clattered12178402_clattered
flattered13188622_flattered
pattered112714202_p_attered
plastered1288892_plastered
scattered12197352s_cattered
shattered13178202s_hattered
slathered13148542s_lathered
smattered12186782s_mattered
splatted11356742splatt__ed
splatter10348882splatter__
splatters11327542splatter_s
splintered1383922splintered
splutterer12132742splutterer
sputtered12166322sp_uttered
squattered2043252squattered
battered113315053__battered
bespattered1681723besp_attered
betattered1343143betattered
blathered15168353_blathered
chattered15197993_chattered
clatterer11186983_clatterer
cluttered12185943_cluttered
flattened13185303_flattened
flatterer12187673_flatterer
flittered13196253_flittered
fluttered13185943_fluttered
glittered11195403_glittered
lathered121512323__lathered
lettered92910783__lettered
littered92511383__littered
mattered112412903__mattered
nattered92011623__nattered
paltered113012483_p_altered
pattened11299393_p_attened
patterer103112173_p_atterer
patterned1265743_p_atterned
plaistered1344133_plaistered
plasterer1178103_plasterer
platted103614263_platt__ed
platter93917413_platter__
platters103415283_platter_s
pottered112311663_p_ottered
puttered112611143_p_uttered
relettered1144333relettered
replastered1442483replastered
scatterer11186293s_catterer
scuttered12166423s_cuttered
shatterer12177203s_hatterer
shuttered13156333s_huttered
skittered1434633s_kittered
slabbered14165083s_labbered
slandered1137473s_landered
slatted84015183s_latt__ed
slattern837093s_latter_n
slatterns935363s_latterns
slavered12188033s_la_vered
slithered13136623s_lithered
smatterer11185813s_matterer
spatted104014143sp_att__ed
spatter94016523sp_atter__
spatters103914703sp_atter_s
splattering1454543splattering
splitter10348443splitter__
splitters11307323splitter_s
splutter10357443splutter__
splutterers13142163splutterers
splutters11286273splutter_s
spluttery14293623splutter_y
sprattled1263313spratt_led
sputterer11165263sp_utterer
stuttered10145763s_tuttered
tattered92011443__tattered
unlettered1143953unlettered
upgathered1742023upgathered
yattered12239533__yattered

Search took 7 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 Filter1786911406030.420425454.8
2DLD Change Limit140603795.97023551.6
3Display Results79790.0461717.4
 (SQL Overall)178691796.43627764.3
 
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.