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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

162 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
rottennesses124441(None) 
rootednesses1345312rootednesses
rottenness1043762rottenne_s_s
bitternesses1444533bitternesses
brokennesses1843303bro_kennesses
dottinesses1238123dott_inesses
frozennesses2443223fro_zennesses
goldennesses1443793goldennesses
notednesses1247773no_tednesses
opennesses1246313_o_pennesses
othernesses1475423_othernesses
pottinesses1339093pott_inesses
rootinesses1139513root_inesses
rotundnesses1343823rotundnesses
ruttinesses11128983rutt_inesses
soddennesses1443203soddennesses
utternesses1145873_utternesses
wontednesses1645983wontednesses
woodennesses1643653woodennesses
acutenesses13126964acute_nesses
aliennesses1145864_aliennesses
astutenesses1245594astute_nesses
barrennesses1443424barrennesses
battinesses13169454batt_inesses
betweennesses1871774betweennesses
bittinesses13148264bitt_inesses
brattinesses1466254bratt_inesses
brazennesses2343284brazennesses
brittlenesses1584204brittlenesses
brownnesses1664374bro__wnnesses
cattinesses13129704catt_inesses
commonnesses18103184commonnesses
costlinesses1446244costlinesses
cravennesses1744104cravennesses
crookednesses2052604crookednesses
crowdednesses2053174crowdednesses
cutenesses12910894_cute_nesses
datednesses1357894_datednesses
doggednesses1643704doggednesses
donenesses11310564do_ne_nesses
dopeynesses1744024do_peynesses
drivennesses1643814drivennesses
drunkennesses1861854drunkennesses
elatednesses1346094elatednesses
evennesses1345924__evennesses
fattinesses14118974fatt_inesses
fittingnesses1773404fittingnesses
frostinesses1546524frost_inesses
frothinesses1845594fro_thinesses
giftednesses1754004giftednesses
gonenesses11310254go_ne_nesses
gooeynesses1544194go_oeynesses
goutinesses1239964gout_inesses
governesses1546714go_vernesses
greennesses1247024_greennesses
grittinesses1345834gritt_inesses
growthinesses2042604growthinesses
hiddennesses1752654hiddennesses
hokeynesses2193714ho_keynesses
homeynesses1984814ho_meynesses
hoodednesses1744494hoodednesses
hornednesses1645504hornednesses
hotnesses1238904ho_t__nesses
intentnesses1277124_intentnesses
iratenesses11411414irate_nesses
ironnesses1047824iro___nnesses
jettinesses1836384jett_inesses
jitterinesses2083314jitterinesses
jointednesses2174014jointednesses
keennesses1445324__keennesses
knottinesses1643904knott_inesses
latenesses10413354_late_nesses
leadennesses1354574leadennesses
litenesses10513014_lite_nesses
lithenesses1447304lithe_nesses
littlenesses1246074littlenesses
loathnesses1445854loat_hnesses
loftinesses1437914loft_inesses
lonenesses10311344lo_ne_nesses
loosenesses1147244loose_nesses
lornnesses1037824lo__rnnesses
lostnesses1049304lost__nesses
mateynesses1645164_mateynesses
modernnesses1543864modernnesses
mootnesses1237154moot__nesses
morenesses12811384mo_re_nesses
mutenesses1289954_mute_nesses
nattinesses11119314natt_inesses
noblenesses1348054noble_nesses
nothingnesses1752754nothingnesses
nuttinesses11117744nutt_inesses
onenesses9311824_o_ne_nesses
ornatenesses1257284ornate_nesses
petitenesses14169324petite_nesses
pettinesses1338624pett_inesses
pointednesses1654954pointednesses
politenesses1448564polite_nesses
porteresses1345504porte_resses
portlinesses1446974portlinesses
prettinesses1447514prett_inesses
profanenesses1853464profanenesses
pronenesses1379254pro_ne_nesses
propernesses1645004pro_pernesses
raggednesses1543854raggednesses
raptnesses1248524rapt__nesses
rarenesses10313094r_are_nesses
recentnesses1465364r_ecentnesses
rednesses10312304r___ednesses
relatednesses1444984relatednesses
remotenesses1446794remote_nesses
retirednesses1454554retirednesses
rifenesses1339934r_ife_nesses
riotousnesses1357304riotousnesses
ripenesses12310364r_ipe_nesses
ritzinesses2096744r_itzinesses
robustnesses1443784robustnesses
rockinesses1737354ro_ckinesses
roominesses1337424ro_ominesses
rootedness1144904rootedne_s_s
rootlessnesses1346594rootlessnesses
ropinesses121311024ro__pinesses
rosinesses101213144ro__sinesses
rottenest949604rotte_ne_s_t
rottenstones1251454rottenstones
roughnesses15105134ro_ughnesses
roundednesses1554284roundednesses
roundnesses1247044ro_undnesses
rowdinesses1536964ro_wdinesses
rudenesses1188874r_ude_nesses
ruggednesses1543314ruggednesses
runtinesses111210954runt_inesses
rustinesses11911544rust_inesses
ruttishnesses1644034ruttishnesses
snottinesses1255834snott_inesses
sobernesses1346594so_bernesses
softnesses1337604soft__nesses
solemnnesses1443634solemnnesses
solenesses10412704so_le_nesses
sombernesses1643614sombernesses
sootinesses11410044soot_inesses
sorenesses101313484so_re_nesses
sottishnesses1544444sottishnesses
southernnesses1751864southernnesses
spottinesses1445684spott_inesses
steepnesses1345924_steepnesses
sternnesses1146634_sternnesses
suddennesses1442864suddennesses
sullennesses1244344sullennesses
tattinesses11128944tatt_inesses
thinnesses1346264__thinnesses
tritenesses11710364trite_nesses
tweenesses1345804__tweenesses
unevennesses1544074unevennesses
uprootednesses1752324uprootednesses
votivenesses1847554votivenesses
wantonnesses1542894wantonnesses
whitenesses1746644white_nesses
wittinesses14127484witt_inesses
woenesses1239134wo__e_nesses
womannesses1644374wo_mannesses
wornnesses1337134wo__rnnesses
worthinesses1845754worthinesses

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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901627.84315911.0
3Display Results1621620.0931741.9
 (SQL Overall)1786911628.07622126.2
 
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.