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

141 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
tautened93542(None) 
battened11259572battened
fastened12257852fastened
fattened12268282fattened
hastened12239102hastened
latened8711922la_tened
pattened11299392pattened
rattened9218622rattened
sauteed8349612saute_ed
stoutened1053572stoutened
tattered92011442tattered
tauted75317112taut__ed
tauten64311892tauten__
tautens7317842tauten_s
aliened81011743_aliened
altered83215733_altered
anteed75616113_ante_ed
atoned75417543_a_toned
attend7258973_atten_d
attended1035763_attended
attuned835173_attuned
augend837633_augen_d
autoed7712823_aut_oed
bantered113313633bantered
bartend1038753barten_d
bartended1344663bartended
bartered113113013bartered
battener10369393battener
battered113315053battered
butene8312623_butene_
butenes9313033_butenes
caftaned1445093caftaned
cantered113415983cantered
cantoned111411523cantoned
careened1139193careened
cartoned111312833cartoned
catered103117763ca_tered
cautioned1245363cautioned
chastened1545883chastened
dampened1435623dampened
darkened1435943darkened
dauted84114933daut__ed
davened124610073da_vened
faltered122810983faltered
fastener11227833fastener
fattener11268113fattener
flattened13185303flattened
gardened1137003gardened
gartered10319583gartered
haltered123112553haltered
happened1635653happened
haptene123810933haptene_
haptenes133810823haptenes
hardened1338613hardened
harkened1637483harkened
hastener11259133hastener
havened14429243ha_vened
heartened1347063heartened
kittened1334523kittened
ladened979053la_dened
laureled934543laureled
listened9168813listened
loudened1044693loudened
maddened1334893maddened
mastered112614003mastered
mattered112412903mattered
mittened1136363mittened
mutined103311353_mutined
nattered92011623nattered
neatened937043neatened
neutered937423neutered
paltered113012483paltered
patented1188893pa_tented
patined105114783pa_tined
pattered112714203pattered
patterned1265743patterned
paupered13216933paupered
queened17105863_queened
raftered1237663raftered
rattener8238533rattener
ravened115012283ra_vened
saddened1135343saddened
sauntered1036283sauntered
sauted74119603saut__ed
sauterne846253sauterne_
sauternes947023sauternes
smartened1244263smartened
softened1235663softened
stamened1137633sta_mened
straitened1143783straitened
tabered103311593ta_bered
tableted1137533tableted
talented938423ta_lented
taloned8310223ta_loned
tampered13279463tampered
tamponed1336023tamponed
tanned75219953ta__nned
tapered102612933ta_pered
targeted1037483targeted
tarted74923373tart__ed
tarweed1137343tarwe_ed
tasseled935583tasseled
tasted74123973tast__ed
tatted74920533ta_t_ted
tattled84311483ta_ttled
tattooed944573tattooed
taunted84310963tau_nted
taurine7311363taurine_
taurines8310543taurines
tautening1035843tautening
tauter64318023taut__er
tautest72612443taute_st
tauting83316383tautin_g
tautness8217183tautness
tautomer1044593tautomer
tautonym1342983tautonym
teetered9258303teetered
tentered96412103tentered
tightened1444963tightened
tittered9239493tittered
tokened1236393t_okened
tottered9208703tottered
toughened1444223toughened
touted74419743tout__ed
trusteed9346533truste_ed
tuned64622313t_u__ned
tunned74014493t_u_nned
turned73914473t_u_rned
tutee5423523t_ute_e_
tutees6514553t_ute_es
tutored837553t_utored
tutoyed1133943t_utoyed
tutted75117443t_ut_ted
tutued7349413t_ut_ued
waitered1238753waitered
wakened1546873wa_kened
wantoned12117223wantoned
watered113014953wa_tered
whitened1535173whitened
yattered12239533yattered
youthened1644143youthened

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621418.42317352.7
3Display Results1411410.0433279.1
 (SQL Overall)1786911418.62220725.0
 
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.