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

191 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
bandinesses1410972(None) 
bawdinesses17126311bawdinesses
handinesses151410271handinesses
randinesses121311201randinesses
sandinesses12911391sandinesses
badnesses1239242ba_d_nesses
bagginesses1545942bagginesses
baldnesses1337642bald_nesses
balkinesses1767492balkinesses
balminesses1537242balminesses
bandiness122310242bandine_s_s
battinesses13169442battinesses
beadinesses1449552beadinesses
blandnesses1446622bland_nesses
boninesses121111442bon_inesses
bonninesses1337342bonninesses
candidnesses1685392candidnesses
canninesses1368852canninesses
fancinesses1638142fancinesses
gaudinesses1337842gaudinesses
hardinesses151110212hardinesses
lankinesses1539012lankinesses
manginesses1499592manginesses
manlinesses13910192manlinesses
ranginesses121210112ranginesses
tanginesses1278882tanginesses
tardinesses121110242tardinesses
windinesses1557812windinesses
zaninesses19310372zan_inesses
achinesses1539293_achinesses
acidnesses1337253_acidnesses
airinesses102613603_airinesses
angrinesses1247283_angrinesses
antsinesses1148743_antsinesses
aridnesses1139933_aridnesses
artinesses10815193_artinesses
ashinesses1339153_ashinesses
avidnesses1436463_avidnesses
barenesses12311693ba_renesses
baronesses1238903ba_ronesses
basenesses12310553ba_senesses
bassnesses1136833ba_ssnesses
bawdiness15235543bawdine_s_s
beefinesses1675943beefinesses
beerinesses1398903beerinesses
bindingnesses1753273bindingnesses
bittinesses13148253bittinesses
blanknesses1744933blan_knesses
blindnesses1446183blind_nesses
blondnesses1445533blond_nesses
bloodinesses1544263bloodinesses
blowinesses1635973blowinesses
bogginesses1555663bogginesses
boldnesses1337223bold_nesses
boozinesses22175793boozinesses
boskinesses17136803boskinesses
bossinesses12117343bossinesses
boundnesses1446613bound_nesses
boxinesses19127893b_oxinesses
braininesses1446543braininesses
brassinesses1346053brassinesses
brattinesses1466253brattinesses
brawninesses1744703brawninesses
brininesses1338973brininesses
broodinesses1544733broodinesses
bugginesses1545363bugginesses
bulginesses1466123bulginesses
bulkinesses1786473bulkinesses
bumpinesses17126363bumpinesses
burlinesses1338393burlinesses
bushinesses16107453bushinesses
businesses121411353b_usinesses
bustinesses131310073bustinesses
caginesses13310933ca_ginesses
cakinesses16310603ca_kinesses
campinesses1737113campinesses
canonesses1238413can_onesses
cattinesses13129703cattinesses
chancinesses1945033chancinesses
crankinesses1846143crankinesses
daffinesses1834843daffinesses
dailinesses1249493dailinesses
daintinesses1346243daintinesses
danknesses1536253dan_knesses
dinginesses1337473dinginesses
dowdinesses1635723dowdinesses
earlinesses11311033earlinesses
easinesses10314413ea_sinesses
fattinesses14118973fattinesses
fondnesses1437703fond_nesses
funkinesses18136993funkinesses
funninesses14106863funninesses
gabbinesses1634903gabbinesses
gaminesses13410453ga_minesses
gassinesses1197963gassinesses
gauzinesses2136033gauzinesses
gawkinesses1935633gawkinesses
giddinesses1435303giddinesses
grandnesses1348113grand_nesses
hairinesses14198943hairinesses
hamminesses1835773hamminesses
handednesses1765643handednesses
handiness132110933handine_s_s
handpresses1753653handpresses
happinesses1876163happinesses
hardnesses141810543hard_nesses
hastinesses141210683hastinesses
hazinesses2239213ha_zinesses
headinesses1539843headinesses
inkinesses1439413_inkinesses
jauntinesses1944683jauntinesses
jazzinesses2633373jazzinesses
kindlinesses1744243kindlinesses
kindnesses1537213kind_nesses
kinkinesses1435873kinkinesses
lacinesses12312103la_cinesses
lanknesses1437503lan_knesses
larkinesses1538993larkinesses
lazinesses19310143la_zinesses
madnesses1239833ma_d_nesses
maltinesses13310223maltinesses
massinesses12128683massinesses
matinesses12314523ma_tinesses
mazinesses2139903ma_zinesses
moldinesses14138043moldinesses
moodinesses14147643moodinesses
muddinesses1535263muddinesses
nappinesses1555923nappinesses
nastinesses111110723nastinesses
nattinesses11119313nattinesses
needinesses1258103needinesses
nerdinesses1249043nerdinesses
pastinesses13911703pastinesses
pawkinesses2036153pawkinesses
puninesses121110743pun_inesses
punkinesses17127213punkinesses
rabidnesses1476123rabidnesses
racinesses12313493ra_cinesses
raininesses11310473raininesses
rancidnesses1544883rancidnesses
randiness102511443randine_s_s
randomnesses1553533randomnesses
ranknesses1438093ran_knesses
rapidnesses1476463rapidnesses
raspinesses1338003raspinesses
readinesses12611263readinesses
reedinesses1259553reedinesses
rowdinesses1536963rowdinesses
ruddinesses1336023ruddinesses
runninesses11137683runninesses
runtinesses111210943runtinesses
sadnesses10310303sa_d_nesses
saltinesses11311443saltinesses
sandiness102111713sandine_s_s
sanenesses10412693san_enesses
sappinesses1567563sappinesses
sassinesses999313sassinesses
saucinesses1338953saucinesses
savvinesses1735663savvinesses
scantinesses1437313scantinesses
seedinesses1259203seedinesses
shadinesses1538643shadinesses
slanginesses1346963slanginesses
snakinesses1538553snakinesses
sunninesses11148373sunninesses
swankinesses1944783swankinesses
tackinesses1737253tackinesses
talkinesses1537353talkinesses
tarrinesses11129083tarrinesses
tartinesses111011493tartinesses
tastinesses111110773tastinesses
tattinesses11128943tattinesses
tawdrinesses1643433tawdrinesses
tawninesses1436153tawninesses
tidinesses1139213_tidinesses
tininesses10311153tin_inesses
tinninesses1136863tinninesses
trendinesses1346323trendinesses
unhandinesses1753713unhandinesses
validnesses1576023validnesses
vapidnesses1774893vapidnesses
wackinesses2036653wackinesses
wannesses1239233wan__nesses
warinesses131514513wa_rinesses
washinesses1737253washinesses
waspinesses1636693waspinesses
wavinesses16199273wa_vinesses
waxinesses20138753wa_xinesses
weedinesses1557073weedinesses
woodinesses15127463woodinesses
wordinesses15138873wordinesses

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 Limit1216331915.47022236.4
3Display Results1911910.1101736.4
 (SQL Overall)1786911915.72031239.7
 
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.