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
bandinesses1410973(None) 
bawdinesses17126321bawdinesses
handinesses151410271handinesses
randinesses121311201randinesses
sandinesses12911391sandinesses
badnesses1239252ba_d_nesses
bagginesses1545952bagginesses
baldnesses1337652bald_nesses
balkinesses1767502balkinesses
balminesses1537252balminesses
bandiness122310242bandine_s_s
battinesses13169452battinesses
beadinesses1449562beadinesses
blandnesses1446622bland_nesses
boninesses121111452bon_inesses
bonninesses1337352bonninesses
candidnesses1685392candidnesses
canninesses1368852canninesses
fancinesses1638142fancinesses
gaudinesses1337852gaudinesses
hardinesses151110212hardinesses
lankinesses1539012lankinesses
manginesses1499592manginesses
manlinesses13910192manlinesses
ranginesses121210112ranginesses
tanginesses1278882tanginesses
tardinesses121110242tardinesses
windinesses1557812windinesses
zaninesses19310382zan_inesses
achinesses1539303_achinesses
acidnesses1337253_acidnesses
airinesses102613613_airinesses
angrinesses1247283_angrinesses
antsinesses1148753_antsinesses
aridnesses1139933_aridnesses
artinesses10815213_artinesses
ashinesses1339163_ashinesses
avidnesses1436463_avidnesses
barenesses12311703ba_renesses
baronesses1238913ba_ronesses
basenesses12310563ba_senesses
bassnesses1136843ba_ssnesses
bawdiness15235543bawdine_s_s
beefinesses1675953beefinesses
beerinesses1398923beerinesses
bindingnesses1753273bindingnesses
bittinesses13148263bittinesses
blanknesses1744933blan_knesses
blindnesses1446183blind_nesses
blondnesses1445543blond_nesses
bloodinesses1544273bloodinesses
blowinesses1635983blowinesses
bogginesses1555673bogginesses
boldnesses1337233bold_nesses
boozinesses22175803boozinesses
boskinesses17136813boskinesses
bossinesses12117353bossinesses
boundnesses1446623bound_nesses
boxinesses19127903b_oxinesses
braininesses1446553braininesses
brassinesses1346063brassinesses
brattinesses1466263brattinesses
brawninesses1744703brawninesses
brininesses1338983brininesses
broodinesses1544743broodinesses
bugginesses1545373bugginesses
bulginesses1466133bulginesses
bulkinesses1786483bulkinesses
bumpinesses17126373bumpinesses
burlinesses1338403burlinesses
bushinesses16107463bushinesses
businesses121411373b_usinesses
bustinesses131310093bustinesses
caginesses13310943ca_ginesses
cakinesses16310613ca_kinesses
campinesses1737113campinesses
canonesses1238423can_onesses
cattinesses13129703cattinesses
chancinesses1945033chancinesses
crankinesses1846143crankinesses
daffinesses1834843daffinesses
dailinesses1249493dailinesses
daintinesses1346243daintinesses
danknesses1536253dan_knesses
dinginesses1337473dinginesses
dowdinesses1635723dowdinesses
earlinesses11311043earlinesses
easinesses10314443ea_sinesses
fattinesses14118973fattinesses
fondnesses1437703fond_nesses
funkinesses18137003funkinesses
funninesses14106873funninesses
gabbinesses1634903gabbinesses
gaminesses13410463ga_minesses
gassinesses1197973gassinesses
gauzinesses2136043gauzinesses
gawkinesses1935633gawkinesses
giddinesses1435303giddinesses
grandnesses1348113grand_nesses
hairinesses14198943hairinesses
hamminesses1835773hamminesses
handednesses1765643handednesses
handiness132110933handine_s_s
handpresses1753653handpresses
happinesses1876163happinesses
hardnesses141810543hard_nesses
hastinesses141210693hastinesses
hazinesses2239223ha_zinesses
headinesses1539843headinesses
inkinesses1439423_inkinesses
jauntinesses1944683jauntinesses
jazzinesses2633373jazzinesses
kindlinesses1744243kindlinesses
kindnesses1537213kind_nesses
kinkinesses1435873kinkinesses
lacinesses12312123la_cinesses
lanknesses1437503lan_knesses
larkinesses1538993larkinesses
lazinesses19310153la_zinesses
madnesses1239833ma_d_nesses
maltinesses13310233maltinesses
massinesses12128693massinesses
matinesses12314543ma_tinesses
mazinesses2139923ma_zinesses
moldinesses14138043moldinesses
moodinesses14147643moodinesses
muddinesses1535273muddinesses
nappinesses1555923nappinesses
nastinesses111110743nastinesses
nattinesses11119323nattinesses
needinesses1258103needinesses
nerdinesses1249053nerdinesses
pastinesses13911713pastinesses
pawkinesses2036153pawkinesses
puninesses121110753pun_inesses
punkinesses17127223punkinesses
rabidnesses1476133rabidnesses
racinesses12313513ra_cinesses
raininesses11310483raininesses
rancidnesses1544883rancidnesses
randiness102511443randine_s_s
randomnesses1553533randomnesses
ranknesses1438093ran_knesses
rapidnesses1476473rapidnesses
raspinesses1338013raspinesses
readinesses12611273readinesses
reedinesses1259563reedinesses
rowdinesses1536963rowdinesses
ruddinesses1336033ruddinesses
runninesses11137693runninesses
runtinesses111210963runtinesses
sadnesses10310303sa_d_nesses
saltinesses11311453saltinesses
sandiness102111713sandine_s_s
sanenesses10412693san_enesses
sappinesses1567563sappinesses
sassinesses999323sassinesses
saucinesses1338983saucinesses
savvinesses1735663savvinesses
scantinesses1437313scantinesses
seedinesses1259203seedinesses
shadinesses1538643shadinesses
slanginesses1346963slanginesses
snakinesses1538553snakinesses
sunninesses11148383sunninesses
swankinesses1944783swankinesses
tackinesses1737253tackinesses
talkinesses1537353talkinesses
tarrinesses11129083tarrinesses
tartinesses111011503tartinesses
tastinesses111110783tastinesses
tattinesses11128943tattinesses
tawdrinesses1643433tawdrinesses
tawninesses1436153tawninesses
tidinesses1139223_tidinesses
tininesses10311163tin_inesses
tinninesses1136863tinninesses
trendinesses1346323trendinesses
unhandinesses1753713unhandinesses
validnesses1576023validnesses
vapidnesses1774893vapidnesses
wackinesses2036653wackinesses
wannesses1239233wan__nesses
warinesses131514523wa_rinesses
washinesses1737263washinesses
waspinesses1636703waspinesses
wavinesses16199283wa_vinesses
waxinesses20138763wa_xinesses
weedinesses1557073weedinesses
woodinesses15127463woodinesses
wordinesses15138883wordinesses

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 Filter1786911216330.403443402.0
2DLD Change Limit1216331915.47022236.4
3Display Results1911910.1101736.4
 (SQL Overall)1786911915.98329866.5
 
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.