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

209 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
scratchinesses215176(None) 
scratchiness1962382scratchine_s_s
crunchinesses2052863_crunchinesses
patchinesses1944363__patchinesses
scrappinesses1952293scra_ppinesses
scrawninesses1842423scra_wninesses
sketchinesses2251883s_ketchinesses
starchinesses1843213s_tarchinesses
swarthinesses1943453swart_hinesses
achinesses1539304___a_chinesses
bitchinesses1943524__bitchinesses
brattinesses1466264_brat_tinesses
breathinesses1853674breat_hinesses
cattinesses13129704_c_at_tinesses
chancinesses1945034_chanc_inesses
chattinesses1755154_chat_tinesses
craftinesses1746384_cra_ftinesses
cragginesses1644504_cra_gginesses
crankinesses1846144_cra_nkinesses
crazinesses2237934_cra__zinesses
crotchetinesses2261084_crotchetinesses
earthinesses1545824ear_t_hinesses
frothinesses1845594_frot_hinesses
grouchinesses1942664_grouchinesses
itchinesses1644614___itchinesses
preachinesses2043754_preachinesses
racinesses12313514__ra_c_inesses
raunchinesses1842634__raunchinesses
saucinesses1338984s__auc_inesses
scalinesses1339324sc_a__linesses
scantinesses1437314sc_a_ntinesses
scarcenesses1644494sc_arc_enesses
scarinesses1339904sc_a__rinesses
scratchiest1844144scratchi_e_s_t
screwinesses1744744scr__ewinesses
scruffinesses2151564scr_uffinesses
slatinesses11311634s_lat__inesses
slouchinesses1842804s_louchinesses
spacinesses1538104s_pa_c_inesses
splashinesses1742734spla_shinesses
squashinesses2442384squa_shinesses
statelinesses1344234s_tatelinesses
stealthinesses1751954stealthinesses
straightnesses1872584straightnesses
sweatinesses1546914sweat__inesses
tetchinesses1753554__tetchinesses
trashinesses1546114_tra_shinesses
worthinesses1845764wor_t_hinesses
archnesses1547175___arch_nesses
artinesses10815225_ar_t__inesses
artsinesses1138735_ar_t_sinesses
ashinesses1339165___a_shinesses
battinesses13169455__bat_tinesses
braininesses1446555_bra_ininesses
brashnesses1646555_bra_sh_nesses
brassinesses1346075_bra_ssinesses
brawninesses1744705_bra_wninesses
butchnesses1843705__butch_nesses
caginesses13310945_c_a__ginesses
cakinesses16310615_c_a__kinesses
campinesses1737115_c_a_mpinesses
canninesses1368855_c_a_nninesses
charinesses1639565_cha__rinesses
churchlinesses2451395_churchlinesses
clamminesses1873795_cla_mminesses
classinesses1366115_cla_ssinesses
cockinesses1947565_c__ockinesses
costlinesses1446255_cost_linesses
crabbednesses2072945_crabbednesses
crassnesses1246655_cra__ssnesses
cravennesses1744115_cra_vennesses
creakinesses1845995_cr_eakinesses
creaminesses1646135_cr_eaminesses
creativenesses1967035_creativenesses
creepinesses1645255_cr_eepinesses
crispinesses1645015_cr_ispinesses
criticalnesses1853155_criticalnesses
crumblinesses1952895_crumblinesses
crumminesses1843655_cr_umminesses
crunchiness1843285_crunchine_s_s
crustinesses14137645_cr_ustinesses
cushinesses16127415_c__ushinesses
dilatorinesses1552055dilatorinesses
dirtinesses1239885dir_t__inesses
draftinesses1645755_dra_ftinesses
earthlinesses1643915ear_thlinesses
fancinesses1638145__fanc_inesses
fattinesses14118975__fat_tinesses
filthinesses1844465_filt_hinesses
flashinesses18124865_fla_shinesses
gauchenesses1843325__gauchenesses
graininesses1346605_gra_ininesses
graphicnesses2151845_gra_phicnesses
grapinesses1438585_gra__pinesses
grittinesses1345865_grit_tinesses
growthinesses2042615_growthinesses
healthinesses1942965_healthinesses
heartinesses1548005heart__inesses
iratenesses11411445_irat__enesses
lacinesses12312125__la_c_inesses
lengthinesses1752145lengt_hinesses
loathnesses1445865_loat_h_nesses
lucrativenesses2054375lucrativenesses
marchionesses2052365__marchionesses
marshinesses1744965__marshinesses
matinesses12314545__mat__inesses
meatinesses13311985_meat__inesses
nattinesses11119325__nat_tinesses
patchiness1744935__patchine_s_s
paunchinesses2042345_paunchinesses
pithinesses1637505__pit_hinesses
portlinesses1446995por_t_linesses
prettinesses1447545_pret_tinesses
raininesses11310495__ra_ininesses
rancidnesses1544885__rancidnesses
randinesses121311205__ra_ndinesses
ranginesses121210115__ra_nginesses
rashnesses1338725__ra_sh_nesses
raspinesses1338015__ra_spinesses
richnesses1537805__r_ich_nesses
ritzinesses2096755__rit_zinesses
rockinesses1737365__r_ockinesses
ruttinesses11128995__rut_tinesses
saintlinesses1344365saint_linesses
saltinesses11311455s__a_ltinesses
salutarinesses1462775salutarinesses
sandinesses12911395s__a_ndinesses
sappinesses1567565s__a_ppinesses
sassinesses999325s__a_ssinesses
savorinesses1544615s__avorinesses
savvinesses1735665s__a_vvinesses
scantnesses1376535sc_a__ntnesses
scrappiness1752295scra_ppine_s_s
scratchers1744295scratch__e__rs
scratches1647325scratch_____es
scratchier1744345scratchi____er
scratching1844535scratchin____g
scrawniness1652155scra_wnine_s_s
scrutinises1363305scrut__in_ises
scurvinesses1743935sc__urvinesses
seaminesses13310755s_ea__minesses
secretivenesses2055685secretivenesses
sedatenesses1346965sedat__enesses
shabbinesses1953435s_ha_bbinesses
shadinesses1538645s_ha__dinesses
shadowinesses2052145s_hadowinesses
shagginesses1743965s_ha_gginesses
shakinesses1837615s_ha__kinesses
shapelinesses1843415s_hapelinesses
shiftinesses18105245shift__inesses
sightlinesses1743865sight_linesses
sketchiness2052175s_ketchine_s_s
slacknesses1745245s_la_c_knesses
slanginesses1346965s_la_nginesses
sleazinesses2145375slea__zinesses
slushinesses1445475s__lushinesses
smarminesses1645105s_ma_rminesses
smartnesses1337145smart___nesses
smoothnesses1762655smoot_h_nesses
smuttinesses14135085s_mut_tinesses
snakinesses1538555s_na__kinesses
snappinesses1684325s_na_ppinesses
sneakinesses1645905snea__kinesses
snootinesses1265805snoot__inesses
snottinesses1255845s_not_tinesses
soapinesses1339715s_oa__pinesses
solitarinesses1452975solitarinesses
sootinesses11410055s_oot__inesses
sorrinesses11310095sor___rinesses
spicinesses1547105s__pic_inesses
sportinesses1447875sport__inesses
spottinesses1445685s_pot_tinesses
springinesses16104075spr_inginesses
sprucenesses1694615spr_uc_enesses
squatnesses2045215squat___nesses
squishinesses2442945s_quishinesses
staginesses1238465s___taginesses
starchiness1643945s_tarchine_s_s
staunchnesses1851465staunch_nesses
steadinesses1346905stea__dinesses
steaminesses1446225stea__minesses
stickinesses1845085s__tickinesses
stockinesses1844505s__tockinesses
stoninesses1138255s___toninesses
straitnesses1246215stra__itnesses
strandednesses1652825strandednesses
strangenesses1454965stra_ngenesses
streakinesses1743635str_eakinesses
strictnesses1445415str_ic_tnesses
stringinesses14124545str_inginesses
subacidnesses1851695suba_cidnesses
suchnesses1536675s___uch_nesses
sultrinesses1245885s_ult_rinesses
surlinesses11310055sur___linesses
swampinesses1943715s_wa_mpinesses
swankinesses1944785s_wa_nkinesses
swarthiness1743385swart_hine_s_s
swartnesses1436715swart___nesses
tackinesses1737255__ta_ckinesses
tartinesses111011505tar_t__inesses
tattinesses11128945__tat_tinesses
throatinesses1653275throat__inesses
touchinesses1744245__touchinesses
trickinesses1845235_tr_ickinesses
wackinesses2036655__wa_ckinesses
washinesses1737265__wa_shinesses
waterinesses1567195__waterinesses
wealthinesses1942625_wealthinesses
wretchednesses2351505_wretchednesses

Search took 8 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 Limit950242096.51614583.2
3Display Results2092090.1401492.9
 (SQL Overall)1786912097.01625469.1
 
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.