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

150 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
loopinesses1311673(None) 
looninesses1197991looninesses
bloodinesses1544262bloodinesses
boozinesses22175792boozinesses
dopinesses13159712_dopinesses
floppinesses1942952floppinesses
gloominesses1544122gloominesses
goofinesses1535962goofinesses
kookinesses1435372kookinesses
lippinesses1535512lippinesses
loaminesses1358442loaminesses
loftinesses1437912loftinesses
loginesses11410312l_oginesses
loopiness11136542loopine_s_s
loosenesses1147232loosenesses
lousinesses111210302lousinesses
lowlinesses1436682lowlinesses
lumpinesses15107102lumpinesses
moodinesses14147642moodinesses
mooninesses13127942mooninesses
mopinesses14139112_mopinesses
oozinesses19178012_oozinesses
roominesses1337422roominesses
rootinesses1139512rootinesses
ropinesses121311012_ropinesses
sloppinesses1644052sloppinesses
soapinesses1339702soapinesses
sootinesses11410042sootinesses
soppinesses1566842soppinesses
woodinesses15127462woodinesses
woolinesses14157502woolinesses
woozinesses23175632woozinesses
aloofnesses1443413aloo_fnesses
blowinesses1635973blowinesses
bogginesses1555663bogginesses
boninesses121111443_boninesses
bonninesses1337343bonninesses
boskinesses17136803boskinesses
bossinesses12117343bossinesses
boxinesses19127893_boxinesses
broodinesses1544733broodinesses
bumpinesses17126363bumpinesses
campinesses1737113campinesses
choppinesses2143353choppinesses
cloudinesses1545123cloudinesses
cockinesses1947553cockinesses
comfinesses1846903comfinesses
coolnesses1237183coo_lnesses
corkinesses1749203corkinesses
corninesses13410583corninesses
cosinesses121012813_cosinesses
cozinesses21179493_cozinesses
dippinesses1635243dippinesses
dodginesses1435433dodginesses
dorkinesses1647653dorkinesses
dottinesses1238123dottinesses
dowdinesses1635723dowdinesses
downinesses1536143downinesses
dozinesses20168623_dozinesses
dumpinesses16126243dumpinesses
foaminesses1658063foaminesses
fogginesses1645493fogginesses
forkinesses1847993forkinesses
foxinesses20127723_foxinesses
fozinesses22158183_fozinesses
glossinesses1254493glossinesses
godlinesses1337123godlinesses
goodnesses1236433goo_dnesses
gooeynesses1544193gooeynesses
gorinesses11311533_gorinesses
goutinesses1239953goutinesses
grapinesses1438563grapinesses
happinesses1876163happinesses
hippinesses1845493hippinesses
hoarinesses14310213hoarinesses
hokinesses1758933_hokinesses
holinesses13511483_holinesses
hominesses15510843_hominesses
horninesses1458993horninesses
horsinesses1439533horsinesses
humpinesses18106233humpinesses
jokinesses2147523_jokinesses
jollinesses1836723jollinesses
jowlinesses2135323jowlinesses
jumpinesses22125333jumpinesses
lacinesses12312103l_acinesses
lankinesses1539013lankinesses
larkinesses1538993larkinesses
lazinesses19310143l_azinesses
leafinesses1437873leafinesses
leakinesses1538473leakinesses
leerinesses11119473leerinesses
legginesses1345293legginesses
liminesses121310843l_iminesses
limpidnesses1743623limpidnesses
limpnesses14116653limp_nesses
lionesses939423lio__nesses
loathnesses1445853loathnesses
localnesses1345843localnesses
lonelinesses12146343lonelinesses
lonenesses10311343l_onenesses
longnesses1138503l_ongnesses
looniness9137573loonine_s_s
lordlinesses1345153lordlinesses
lornnesses1037823l_ornnesses
lostnesses1049293l_ostnesses
loudnesses1138433l_oudnesses
lovelinesses15125333lovelinesses
lownesses1236983l_o_wnesses
luckinesses1746633luckinesses
lustinesses11910403lustinesses
moldinesses14138043moldinesses
mootnesses1237153moo_tnesses
mossinesses12117453mossinesses
mousinesses13129813mousinesses
nappinesses1555923nappinesses
nippinesses1545063nippinesses
noisinesses1139453noisinesses
nosinesses101411303_nosinesses
oilinesses101512433_oilinesses
peppinesses1435313peppinesses
phoninesses1636453phoninesses
pipinesses1448593_pipinesses
pokinesses1669603_pokinesses
poornesses1236803poo_rnesses
porkinesses1748763porkinesses
pottinesses1339093pottinesses
prosinesses13310843prosinesses
pulpinesses1535993pulpinesses
raspinesses1338003raspinesses
rockinesses1737353rockinesses
rosinesses101213133_rosinesses
rowdinesses1536963rowdinesses
sappinesses1567563sappinesses
showinesses1735993showinesses
sleepinesses1445673sleepinesses
smokinesses1736253smokinesses
snootinesses1265793snootinesses
snowinesses1436413snowinesses
sogginesses1346773sogginesses
sorrinesses11310083sorrinesses
spookinesses1844093spookinesses
stoninesses1138253stoninesses
waspinesses1636693waspinesses
weepinesses1646133weepinesses
wimpinesses1835633wimpinesses
wispinesses1636263wispinesses
woollinesses15113793woollinesses
wordinesses15138873wordinesses
worminesses16127983worminesses

Search took 6 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 Filter1786911216330.1401276364.3
2DLD Change Limit1216331505.44022359.0
3Display Results1501500.0761973.7
 (SQL Overall)1786911505.65631593.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.