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

130 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
idlesses93600(None) 
idlesse834191idlesse_
blesses93812392_blesses
dresses83716172_dresses
idleness936842idleness
idlenesses1138022idlenesses
ileuses738672i_leuses
illnesses937272illnesses
abbesses1235333abbesses
accesses1287493accesses
acidnesses1337253acidnesses
addresses1165633addresses
admasses1135413admasses
aidless83612073aidle_s_s
aridnesses1139933aridnesses
assesses737383assesses
avidnesses1436463avidnesses
badnesses1239243badnesses
bignesses1267953bignesses
blessed10319493_blessed
blesser9329293_blesser
blessers10277623_blessers
blisses94911513_blisses
caresses10314063caresses
celestes10310013celestes
cesses84221363__cesses
chesses124112633_chesses
classes94717943_classes
colessee1098783colessee
colessees11146043colessees
coleuses1039713coleuses
cordlesses1346303cordlesses
cresses94219813_cresses
dieses75218693_die_ses
digresses1137863digresses
dimnesses1238213dimnesses
diseases92415813diseases
diseuses93112753diseuses
disses75225963_d_isses
dosses76126273_d_osses
dressed93511873_dressed
dresser83611953_dresser
dressers9359863_dressers
drosses84513823_drosses
dulnesses1037743dulnesses
duresses939173duresses
egresses949443egresses
eldresses1045673eldresses
esses56422973___esses
excesses1736753excesses
fesses94820253__fesses
finesses111912333finesses
fitnesses12219373fitnesses
flenses1039473_flenses
fleshes133913273_fleshes
flosses103411973_flosses
fulnesses1239033fulnesses
glasses84414273_glasses
glosses84014123_glosses
goddesses1243453goddesses
guesses8169373_guesses
hipnesses1436753hipnesses
icinesses11310053icinesses
ideates8313723id_eates
idlers74012813idle__rs
idles66720123idl___es
idlest74014863idle_s_t
idolises938763idolises
ilexes134510253i_le_xes
immerses1235953immerses
immeshes1543933immeshes
impasses12257523impasses
impresses1338213impresses
incenses102411003incenses
ingresses1038533ingresses
inmeshes1345613inmeshes
inverses112410983inverses
isleless834853isleless
jesses135215953__jesses
kindnesses1537213kindnesses
kirmesses15253903kirmesses
lasses64827593__lasses
leases65428113__leases
lenses64620893__lenses
leses54930813__le_ses
lessee64116363__lessee
lessees73510243__lessees
lessen64212433__lessen
lessens7409383__lessens
lesser63514853__lesser
lidless8309273lidle_s_s
lionesses939423lionesses
loesses7310033_loesses
losses65925233__losses
madnesses1239833madnesses
messes84924343__messes
mildnesses1397393mildnesses
molasses1037233molasses
nesses64718323__nesses
noblesses1145993noblesses
obsesses1036223obsesses
oddnesses1136353oddnesses
ogresses938473ogresses
oldnesses1037703oldnesses
oyesses1037333_oyesses
pelisses1048483pelisses
pleases94515483_pleases
plisses94411773_plisses
plusses93510693_plusses
presses93523153_presses
recesses10312323recesses
rednesses10312303rednesses
redresses10410293redresses
releases8313343releases
sadnesses10310303sadnesses
soleuses838073soleuses
stresses81112493stresses
teleses7313123tele_ses
tidinesses1139213tidinesses
tigresses1046403tigresses
tresses73719543_tresses
undresses1039313undresses
vitesses1136333vitesses
voidnesses1436833voidnesses
widenesses1438773widenesses
wildnesses14157363wildnesses
windlasses1443053windlasses
wirelesses1345333wirelesses
witnesses12219923witnesses
yesses93615813__yesses

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.1731032896.0
2DLD Change Limit1461621308.18617855.1
3Display Results1301300.0632063.5
 (SQL Overall)1786911308.42221217.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.