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

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

142 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
completenesses205399(None) 
completeness1854632completene_s_s
complexnesses26112722comple_xnesses
compactnesses2153003compact_nesses
concretenesses1854163concretenesses
repletenesses1554493_repletenesses
amplenesses1585704_ampl__enesses
collectednesses2062594co_llectednesses
comelinesses1666404com__elinesses
competences1956374comp_eten__ces
competencies2064974comp_eten_cies
complexness2453094comple_xne_s_s
composednesses2152284composednesses
computereses18162784comp_utere_ses
contritenesses1655494contritenesses
homelessnesses18137474homelessnesses
impolitenesses1853954_impolitenesses
incompleteness2062054incompletene_s_s
oblatenesses1475774_o_blatenesses
obsoletenesses1662224obsoletenesses
politenesses1448594po__litenesses
simplenesses1645624simpl__enesses
toplessnesses1446584to_plessnesses
absolutenesses1662405absolutenesses
aimlessnesses1487465aim_lessnesses
bootlessnesses1556455bootlessnesses
campinesses1737115camp___inesses
capablenesses1955455c_apablenesses
carelessnesses1547725carelessnesses
chastenesses1746315c__hastenesses
cleannesses13135825c___leannesses
clearnesses13106155c___learnesses
clevernesses1743635c___levernesses
closenesses1347845c___losenesses
cloudlessnesses1764875cloudlessnesses
coarsenesses1447245co__arsenesses
cockeyednesses2661735co_ckeyednesses
cocksurenesses2261845cocksurenesses
coercivenesses2165655coercivenesses
cohesivenesses2256205cohesivenesses
coldnesses1338425co__l__dnesses
colorlessnesses1665095colorlessnesses
combativenesses2464155combativenesses
comfinesses1846915com___finesses
commonnesses18103185com__monnesses
compactness1953305compact_ne_s_s
competence1846725comp_eten__ce_
complacences1953015complacen__ces
complacencies2062645complacen_cies
complementaries2372345complementaries
complemented2154175complemen__ted
complementizer3172225complementizer
complementizers3291625complementizers
complements1948185complemen___ts
completers16298325complet__e__rs
completes153212925complet_____es
completest16297875complet__e_s_t
compresses1647775comp____resses
computerese17183415comp_utere_se_
computerises18224975comp_ute_rises
comradelinesses2061405comradelinesses
conceitednesses2063695conceitednesses
concertednesses2064215concertednesses
concisenesses1746595co_ncisenesses
concreteness1655055concretene_s_s
conjugatenesses25132415conjugatenesses
connectednesses2063355connectednesses
contentednesses1863745contentednesses
coolnesses1237195co_ol___nesses
copiousnesses1747805co_piousnesses
corporealnesses1961885corporealnesses
correctnesses1754215co_rrectnesses
corruptnesses1752845corrupt_nesses
costivenesses1848165co_stivenesses
costlinesses1446255costl__inesses
covertnesses1746335co__vertnesses
crotchetinesses2261085crotchetinesses
culpablenesses2053905culpablenesses
cutenesses12910905c____utenesses
desolatenesses1553975desolatenesses
dilutenesses1346115__dilutenesses
discretenesses1753385discretenesses
dopeynesses1744025do_p_e_ynesses
doublenesses1546515doubl__enesses
effetenesses1854525__effetenesses
emptinesses1545995_emp__tinesses
femalenesses1746865femal__enesses
fleetnesses1445485___fleetnesses
foodlessnesses1755765foodlessnesses
footlessnesses1656565footlessnesses
formlessnesses1856125formlessnesses
godlessnesses1446585go_dlessnesses
godlikenesses1962665go_dlikenesses
haplessnesses1747255_haplessnesses
helplessnesses1855805helplessnesses
homelinesses1765365hom__elinesses
homeynesses1984815hom__e_ynesses
hopelessnesses18147015hopelessnesses
hornlessnesses1656275hornlessnesses
humblenesses1944975humbl__enesses
impurenesses16164435_imp_urenesses
joblessnesses2155995jo_blessnesses
joylessnesses2255645jo_ylessnesses
latenesses10413365____latenesses
litenesses10513025____litenesses
lovelessnesses1646995lovelessnesses
malenesses12312225__mal__enesses
maltinesses13310235__mal_tinesses
meetnesses1237455__m_eet_nesses
minutenesses1476175__minutenesses
moderatenesses1764405moderatenesses
movelessnesses1846745movelessnesses
mutenesses1289975__m__utenesses
namelessnesses1577055namelessnesses
nimblenesses1656015nimbl__enesses
noblenesses1348075no_bl__enesses
obesenesses1346765_o__besenesses
opaquenesses2352965_o_paquenesses
opennesses1246315_o_p_e_nnesses
oppositenesses1854205_oppositenesses
ornatenesses1257305_o_rnatenesses
planenesses1349035___planenesses
pompousnesses1955465pomp_ousnesses
promptnesses1843635promp__t_nesses
remotenesses1446815rem__otenesses
repleteness1354175_repletene_s_s
resolutenesses1493495resolutenesses
rootlessnesses1346605rootlessnesses
saplessnesses1347275_saplessnesses
solemnnesses1443635so__lemnnesses
solenesses10412705so__l__enesses
sombernesses1643615som_be_rnesses
soullessnesses1296505soullessnesses
supplenesses1643985suppl__enesses
supremenesses1753175_supremenesses
sveltenesses1545235_svel_tenesses
temperatenesses19113155temperatenesses
timelessnesses1547025timelessnesses
tonelessnesses13137655tonelessnesses
toploftinesses1951275to_ploftinesses
wordlessnesses1775875wordlessnesses
worklessnesses20125485worklessnesses

Search took 7 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 Filter178691950240.373479064.3
2DLD Change Limit950241426.36014940.9
3Display Results1421420.0931526.9
 (SQL Overall)1786911426.82626178.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.