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
bloodinesses1544272bloodinesses
boozinesses22175802boozinesses
dopinesses13159722_dopinesses
floppinesses1942952floppinesses
gloominesses1544122gloominesses
goofinesses1535962goofinesses
kookinesses1435372kookinesses
lippinesses1535512lippinesses
loaminesses1358452loaminesses
loftinesses1437922loftinesses
loginesses11410322l_oginesses
loopiness11136542loopine_s_s
loosenesses1147242loosenesses
lousinesses111210322lousinesses
lowlinesses1436682lowlinesses
lumpinesses15107112lumpinesses
moodinesses14147642moodinesses
mooninesses13127942mooninesses
mopinesses14139122_mopinesses
oozinesses19178022_oozinesses
roominesses1337432roominesses
rootinesses1139522rootinesses
ropinesses121311022_ropinesses
sloppinesses1644052sloppinesses
soapinesses1339712soapinesses
sootinesses11410052sootinesses
soppinesses1566842soppinesses
woodinesses15127462woodinesses
woolinesses14157502woolinesses
woozinesses23175632woozinesses
aloofnesses1443413aloo_fnesses
blowinesses1635983blowinesses
bogginesses1555673bogginesses
boninesses121111453_boninesses
bonninesses1337353bonninesses
boskinesses17136813boskinesses
bossinesses12117353bossinesses
boxinesses19127903_boxinesses
broodinesses1544743broodinesses
bumpinesses17126373bumpinesses
campinesses1737113campinesses
choppinesses2143353choppinesses
cloudinesses1545123cloudinesses
cockinesses1947563cockinesses
comfinesses1846913comfinesses
coolnesses1237193coo_lnesses
corkinesses1749213corkinesses
corninesses13410593corninesses
cosinesses121012823_cosinesses
cozinesses21179503_cozinesses
dippinesses1635243dippinesses
dodginesses1435433dodginesses
dorkinesses1647663dorkinesses
dottinesses1238133dottinesses
dowdinesses1635723dowdinesses
downinesses1536143downinesses
dozinesses20168633_dozinesses
dumpinesses16126253dumpinesses
foaminesses1658073foaminesses
fogginesses1645493fogginesses
forkinesses1848003forkinesses
foxinesses20127733_foxinesses
fozinesses22158193_fozinesses
glossinesses1254493glossinesses
godlinesses1337123godlinesses
goodnesses1236433goo_dnesses
gooeynesses1544193gooeynesses
gorinesses11311553_gorinesses
goutinesses1239973goutinesses
grapinesses1438573grapinesses
happinesses1876163happinesses
hippinesses1845493hippinesses
hoarinesses14310223hoarinesses
hokinesses1758943_hokinesses
holinesses13511493_holinesses
hominesses15510863_hominesses
horninesses1459003horninesses
horsinesses1439553horsinesses
humpinesses18106243humpinesses
jokinesses2147533_jokinesses
jollinesses1836723jollinesses
jowlinesses2135323jowlinesses
jumpinesses22125343jumpinesses
lacinesses12312123l_acinesses
lankinesses1539013lankinesses
larkinesses1538993larkinesses
lazinesses19310153l_azinesses
leafinesses1437873leafinesses
leakinesses1538473leakinesses
leerinesses11119483leerinesses
legginesses1345293legginesses
liminesses121310853l_iminesses
limpidnesses1743623limpidnesses
limpnesses14116653limp_nesses
lionesses939433lio__nesses
loathnesses1445863loathnesses
localnesses1345853localnesses
lonelinesses12146343lonelinesses
lonenesses10311343l_onenesses
longnesses1138503l_ongnesses
looniness9137573loonine_s_s
lordlinesses1345173lordlinesses
lornnesses1037823l_ornnesses
lostnesses1049303l_ostnesses
loudnesses1138433l_oudnesses
lovelinesses15125333lovelinesses
lownesses1236983l_o_wnesses
luckinesses1746653luckinesses
lustinesses11910423lustinesses
moldinesses14138043moldinesses
mootnesses1237153moo_tnesses
mossinesses12117463mossinesses
mousinesses13129833mousinesses
nappinesses1555923nappinesses
nippinesses1545063nippinesses
noisinesses1139483noisinesses
nosinesses101411323_nosinesses
oilinesses101512443_oilinesses
peppinesses1435313peppinesses
phoninesses1636453phoninesses
pipinesses1448603_pipinesses
pokinesses1669613_pokinesses
poornesses1236803poo_rnesses
porkinesses1748773porkinesses
pottinesses1339103pottinesses
prosinesses13310853prosinesses
pulpinesses1536003pulpinesses
raspinesses1338013raspinesses
rockinesses1737363rockinesses
rosinesses101213143_rosinesses
rowdinesses1536963rowdinesses
sappinesses1567563sappinesses
showinesses1735993showinesses
sleepinesses1445673sleepinesses
smokinesses1736253smokinesses
snootinesses1265803snootinesses
snowinesses1436413snowinesses
sogginesses1346773sogginesses
sorrinesses11310093sorrinesses
spookinesses1844093spookinesses
stoninesses1138253stoninesses
waspinesses1636703waspinesses
weepinesses1646133weepinesses
wimpinesses1835633wimpinesses
wispinesses1636273wispinesses
woollinesses15113793woollinesses
wordinesses15138883wordinesses
worminesses16127993worminesses

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.390458182.1
2DLD Change Limit1216331504.84325115.2
3Display Results1501500.0931612.9
 (SQL Overall)1786911505.32633550.7
 
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.