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

137 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
clatterer1118698(None) 
chatterer14196841chatterer
clattered12178401clattered
clatterers12155421clatterers
flatterer12187671flatterer
batterer102713212_batterer
blatherer14176712blatherer
blattered12198562blattered
caterer92815932c_a_terer
charterer14197322charterer
chattered15197982chattered
chatterers15205452chatterers
clamberer15185262clamberer
clatter94014972clatt__er
clatters103313902clatter_s
clattery13378192clatter_y
cluttered12185932cluttered
flattener12175172flattener
flattered13188622flattered
flatterers13175912flatterers
flutterer12185262flutterer
latherer111310442_latherer
letterer8259222_letterer
litterer82810172_litterer
patterer103112172_patterer
plasterer1178102plasterer
scatterer11186292scatterer
shatterer12177202shatterer
smatterer11185812smatterer
alterer72713993__alterer
banterer102811773_banterer
barterer102711633_barterer
battener10369393_battener
battered113315053_battered
batterers113110713_batterers
bitterer10309773_bitterer
blathered15168353blathered
blatherers15175343blatherers
blatter94415653blatt__er
blatters104414093blatter_s
blusterer11176293blusterer
cantered113415983c_antered
caperer113013403c_a_perer
capturer1246083c_apturer
careerer1038583c_areerer
catered103117763c_a_tered
caterers102814393c_a_terers
catheter1338153c_atheter
catteries11815513c_atteries
cattery123811603c_atter_y
cattier93317073c_att_ier
chafferer20133923chafferer
chamferer19154683chamferer
chaptered17176783chaptered
chartered15158383chartered
charterers15146043charterers
chastener1445703chastener
chatter124416643chatt__er
chatters134213933chatter_s
chattery16357273chatter_y
chattier1337513chatt_ier
chittered15166413chittered
clabbered16184753clabbered
clambered16146123clambered
clamberers16174103clamberers
clamorer1236903cla_morer
clattering13109233clattering
clavered14187633cla_vered
cleverer1334563cl_everer
clustered12186603clustered
clutter94211653clutt__er
clutters103210343clutter_s
cluttery13346313clutter_y
cottered112511733c_ottered
cratered1149673cra_tered
falterer11239853_falterer
fattener11268113_fattener
fetterer11207813_fetterer
flattened13185303flattened
flatteners13164153flatteners
flatter103815963flatt__er
flatteries1347413flatteries
flatters113814203flatter_s
flattery14338293flatter_y
flittered13196253flittered
fluttered13185943fluttered
flutterers13184593flutterers
fritterer12234403fritterer
gatherer12147903_gatherer
glittered11195403glittered
lateener835763_lateener
lathered121512323_lathered
latherers12158853_latherers
latter65027893_latt__er
latterly1136063_latterly
lettered92910783_lettered
letterers9228113_letterers
littered92511383_littered
litterers9228193_litterers
loiterer837083_loiterer
mattered112412903_mattered
mutterer10218913_mutterer
nattered92011623_nattered
palterer102411273_palterer
pattered112714203_pattered
patterers112410123_patterers
plastered1288893plastered
plasterers1286123plasterers
platter93917413platt__er
platters103415283platter_s
potterer102310263_potterer
putterer10209913_putterer
quarterer18145713quarterer
rattener8238533_rattener
scattered12197353scattered
scatterers12205043scatterers
shattered13178203shattered
shatterers13185723shatterers
slanderer1046673slanderer
slathered13148533slathered
slattern837093slatter_n
slatterns935363slatterns
slaverer11196993sla_verer
smattered12186783smattered
smatterers12174873smatterers
spattered12187643spattered
splattered13163933splattered
splutterer12132743splutterer
sputterer11165263sputterer
stutterer9164913stutterer
tattered92011443_tattered
titterer8268523_titterer
totterer8217793_totterer
twitterer1243303twitterer
utterer71910463__utterer
waterer103314073_wa_terer
yattered12239533_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.280638182.1
2DLD Change Limit1486411378.39017716.4
3Display Results1371370.0632174.6
 (SQL Overall)1786911378.73320461.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.