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

122 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
scatterer1118629(None) 
scattered12197361scattered
scatterers12205041scatterers
shatterer12177201shatterer
smatterer11185811smatterer
batterer102713222_batterer
caterer92815952_ca_terer
chatterer14196842chatterer
clatterer11186992clatterer
flatterer12187682flatterer
patterer103112182_patterer
scamperer1544622scamperer
scatter93815172scatt__er
scatters103612752scatter_s
scattier10267582scatt_ier
scuttered12166422scuttered
shattered13178212shattered
shatterers13185722shatterers
smattered12186792smattered
smatterers12174872smatterers
spattered12187652spattered
sputterer11165262sputterer
stutterer9164912stutterer
alterer72714013__alterer
banterer102811783_banterer
barterer102711653_barterer
battener10369403_battener
battered113315073_battered
batterers113110723_batterers
bitterer10309783_bitterer
blatherer14176723blatherer
blattered12198583blattered
cantered113415993_cantered
caperer113013403_ca_perer
capturer1246103_capturer
careerer1038583_careerer
catered103117783_ca_tered
caterers102814413_ca_terers
catheter1338153_catheter
catteries11815553_catteries
cattery123811603_catter_y
cattier93317073_catt_ier
charterer14197333charterer
chattered15198003chattered
chatterers15205463chatterers
clattered12178423clattered
clatterers12155423clatterers
cottered112511743_cottered
falterer11239873_falterer
fattener11268113_fattener
fetterer11207813_fetterer
flattener12175173flattener
flattered13188643flattered
flatterers13175913flatterers
flutterer12185263flutterer
fritterer12234403fritterer
gatherer12147913_gatherer
latherer111310453_latherer
letterer8259223_letterer
litterer82810173_litterer
mattered112412913_mattered
mutterer10218913_mutterer
nattered92011633_nattered
palterer102411293_palterer
pattered112714213_pattered
patterers112410133_patterers
plasterer1178113plasterer
potterer102310263_potterer
putterer10209913_putterer
quarterer18145723quarterer
rattener8238533_rattener
saunterer945033saunterer
scampered1635233scampered
scamperers1643473scamperers
scanter94215183scant__er
scantier10309983scant_ier
scareder1135793sca_reder
scarer84524613sca___rer
scarpered1435123scarpered
scatted103512773scatt__ed
scattergram1681443scattergram
scattergun1351493scattergun
scattering1398013scattering
sceptered1444723sceptered
scutter93512173scutt__er
scutters103311023scutter_s
shatter103615703shatt__er
shatters113313913shatter_s
shelterer1245043shelterer
shuttered13156333shuttered
skittered1434633skittered
skitterier1442423skitterier
slanderer1046673slanderer
slathered13148553slathered
slattern837093slatter_n
slatterns935363slatterns
slaverer11196993sla_verer
smatter93613333smatt__er
smatters104011713smatter_s
smotherer1444633smotherer
spatter94016523spatt__er
spatters103914703spatter_s
splattered13163943splattered
splutterer12132743splutterer
sputtered12166323sputtered
sputterers12174583sputterers
squattered2043263squattered
staggerer1143923staggerer
stammerer1344063stammerer
steerer73113633s__teerer
stuttered10145763stuttered
stutterers10164303stutterers
swaggerer1442943swaggerer
swatter104113323swatt__er
swatters113911793swatter_s
tattered92011453_tattered
titterer8268523_titterer
totterer8217793_totterer
twitterer1243303twitterer
utterer71910463__utterer
waterer103314083_wa_terer
yattered12239543_yattered

Search took 9 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.436409841.7
2DLD Change Limit1486411227.61019532.3
3Display Results1221220.0631936.5
 (SQL Overall)1786911228.10922036.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.