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

120 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
toploftinesses195127(None) 
toploftiness1751252toploftine_s_s
loftinesses1437923___loftinesses
goofinesses1535964go__of_inesses
pottinesses1339104__p_ottinesses
rootinesses1139524ro__o_tinesses
sootinesses11410054so__o_tinesses
sportinesses1447874_sp_ortinesses
spottinesses1445684_sp_ottinesses
thriftinesses1952324t_hriftinesses
throatinesses1653274t_hroatinesses
toplessnesses1446584topl_essnesses
toploftiest1651524toplofti_e_s_t
bloodinesses1544275__bloodinesses
blowinesses1635985__blo_winesses
boozinesses22175805bo__o_zinesses
cloudinesses1545125__cloudinesses
colorfulnesses1993835co_lorfulnesses
comfinesses1846915co__mf_inesses
completenesses2053995compl_etenesses
copiousnesses1747815copio_usnesses
craftinesses1746385__craftinesses
dolefulnesses1774845do_lefulnesses
dopinesses13159725dop____inesses
dottinesses1238135___dottinesses
doughtinesses1852555do_ughtinesses
draftinesses1645755__draftinesses
emptinesses1545995emp___tinesses
explicitnesses2561315explicitnesses
faultinesses1545185faul__tinesses
flintinesses1546325__flintinesses
floppinesses1942955__floppinesses
fluffinesses1742665__fluffinesses
folksinesses1964065fo_l_ksinesses
forlornnesses1652575forlo_rnnesses
frostinesses1546535__frostinesses
gloominesses1544125__gloominesses
glossinesses1254505__glossinesses
godlinesses1337125godl___inesses
goutinesses1239985___goutinesses
guiltinesses1345125guil__tinesses
heftinesses1737135___heftinesses
holinesses13511495ho_l___inesses
hollownesses1852285hollo__wnesses
hopefulnesses2184595hop_efulnesses
implicitnesses2061815implicitnesses
impolitenesses1853955impolitenesses
jollinesses1836725jo_l__linesses
jowlinesses2135325jowl___inesses
knottinesses1643915__knottinesses
kookinesses1435375ko__o_kinesses
loaminesses1358455___loaminesses
loathnesses1445865___loathnesses
loftiness1236575___loftine_s_s
loginesses11410325___lo_ginesses
looninesses1197995___looninesses
loopinesses13116735___loopinesses
lostnesses1049305___lost_nesses
lousinesses111210335___lousinesses
lowlinesses1436685___lowlinesses
lustinesses11910425___lustinesses
maltinesses13310235_mal__tinesses
moldinesses14138045mo_l__dinesses
moodinesses14147645mo__o_dinesses
mooninesses13127945mo__o_ninesses
mootnesses1237155mo__o_t_nesses
mopinesses14139125mop____inesses
niftinesses1437245___niftinesses
oblatenesses1475775_obl_atenesses
oilinesses101512445_oil___inesses
oozinesses19178025_o__o_zinesses
oppositenesses1854205_oppositenesses
pastinesses13911715__p_astinesses
pettinesses1338635__p_ettinesses
phoninesses1636455__pho_ninesses
pluckinesses2043995__pluckinesses
plushinesses1744725__plushinesses
pokinesses1669615__p_o_kinesses
politenesses1448595po_l_itenesses
populousnesses1864745populo_usnesses
porkinesses1748775__p_orkinesses
portlinesses1446995__p_ortlinesses
prettinesses1447545__prettinesses
prosinesses13310865__pro_sinesses
puffinesses1934515__p_uffinesses
repletenesses1554495repl_etenesses
roominesses1337435ro__o_minesses
ropinesses121311025rop____inesses
saltinesses11311455_sal__tinesses
shiftinesses18105245__shiftinesses
slatinesses11311635__sl_atinesses
sloppinesses1644055__sloppinesses
snootinesses1265805__snootinesses
snottinesses1255845__snottinesses
softnesses1337605___soft_nesses
soppinesses1566845sop___pinesses
soulfulnesses1654555soul_fulnesses
spiffinesses2043015_sp_iffinesses
splashinesses1742735_splashinesses
sponginesses1544775_sp_onginesses
spookinesses1844095_sp_ookinesses
talkinesses1537355t_al__kinesses
tartinesses111011505t___artinesses
tastinesses111110785t___astinesses
tattinesses11128945t___attinesses
testinesses111210325t___estinesses
thirstinesses1642585t_hirstinesses
thorninesses1544395t__horninesses
tipsinesses1336375tip___sinesses
toilsomenesses1662705toilsomenesses
toploftier1551405toplofti____er
touchinesses1744245to__uchinesses
towardlinesses1851915towardlinesses
trustinesses12116995t__rustinesses
uppitinesses16103705_up_pitinesses
woodinesses15127465wo__o_dinesses
woolinesses14157505wo__o_linesses
woollinesses15113795wo__ollinesses
woozinesses23175635wo__o_zinesses
worldlinesses1752815worl_dlinesses

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.360496363.9
2DLD Change Limit950241205.59316989.8
3Display Results1201200.0931290.3
 (SQL Overall)1786911206.04629555.2
 
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.