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

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

86 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
spatters10391470(None) 
patters94825191_patters
scatters103612751scatters
shatters113313911shatters
smatters104011711smatters
spatter94016521spatter_
spitters104113381spitters
splatters11327541splatters
spotters104313381spotters
sputters104012871sputters
swatters113911791swatters
batters94626022_batters
bespatters1442782bespatters
blatters104414092blatters
chatters134213952chatters
clatters103313912clatters
flatters113814202flatters
hatters104221522_hatters
matters94421752_matters
natters73718062_natters
palters94021682_palters
pasters94531732_pasters
paters84935832_pa_ters
pattens95414922_pattens
patter84628262_patter_
pattern93712052_pattern
patterns10439942_patterns
patzers184210572_patzers
petters93722362_petters
platters103415282platters
potters94024342_potters
psalters10227712psalters
putters94219192_putters
ratters74422472_ratters
salters73622252s_alters
scatter93815172scatter_
scutters103311022scutters
seaters74028942sea_ters
setters73822062s_etters
shatter103615702shatter_
shutters113611352shutters
sitters74221552s_itters
skaters113512962ska_ters
skitters12349552skitters
slaters73123732sla_ters
slathers113914782slathers
slattern837092slattern
slatterns935362slatterns
slitters84014132slitters
slotters84012402slotters
smatter93613332smatter_
spacers113813872spa_cers
spaders104214472spa_ders
spallers102910732spallers
spammers14378692spammers
spankers14369862spankers
spanners103710772spanners
sparers94519612spa_rers
spargers11389732spargers
sparkers144111312sparkers
spates85028172spa_te_s
spathes125116532spathe_s
spatted104014142spatte_d
spattered12187642spattered
spawners13396492spawners
specters122811062specters
spelters103912242spelters
spitter94015182spitter_
splatter10348882splatter_
splitters11307322splitters
splutters11286272splutters
sporters103714062sporters
spotter94514882spotter_
spouters104011162spouters
spurters103311702spurters
sputter94014052sputter_
sputtery13366472sputtery
squatters1834942squatters
starters83714772starters
staters73922342sta_ters
stutters83210472stutters
swathers144512082swathers
swatter104113322swatter_
swotters11448482swotters
tatters74520482_tatters
yatters103914622_yatters

Search took 5 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 Filter1786911210590.376475242.0
2DLD Change Limit121059863.85631395.0
3Display Results86860.0332606.1
 (SQL Overall)178691864.26541897.1
 
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.