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
scratchinesses215175(None) 
scratchiness1962382scratchine_s_s
crunchinesses2052853_crunchinesses
patchinesses1944363__patchinesses
scrappinesses1952293scra_ppinesses
scrawninesses1842423scra_wninesses
sketchinesses2251883s_ketchinesses
starchinesses1843213s_tarchinesses
swarthinesses1943453swart_hinesses
achinesses1539294___a_chinesses
bitchinesses1943514__bitchinesses
brattinesses1466254_brat_tinesses
breathinesses1853654breat_hinesses
cattinesses13129704_c_at_tinesses
chancinesses1945034_chanc_inesses
chattinesses1755154_chat_tinesses
craftinesses1746374_cra_ftinesses
cragginesses1644504_cra_gginesses
crankinesses1846144_cra_nkinesses
crazinesses2237924_cra__zinesses
crotchetinesses2261084_crotchetinesses
earthinesses1545814ear_t_hinesses
frothinesses1845594_frot_hinesses
grouchinesses1942654_grouchinesses
itchinesses1644604___itchinesses
preachinesses2043744_preachinesses
racinesses12313494__ra_c_inesses
raunchinesses1842624__raunchinesses
saucinesses1338954s__auc_inesses
scalinesses1339314sc_a__linesses
scantinesses1437314sc_a_ntinesses
scarcenesses1644494sc_arc_enesses
scarinesses1339904sc_a__rinesses
scratchiest1844144scratchi_e_s_t
screwinesses1744744scr__ewinesses
scruffinesses2151564scr_uffinesses
slatinesses11311614s_lat__inesses
slouchinesses1842804s_louchinesses
spacinesses1538094s_pa_c_inesses
splashinesses1742734spla_shinesses
squashinesses2442354squa_shinesses
statelinesses1344234s_tatelinesses
stealthinesses1751954stealthinesses
straightnesses1872584straightnesses
sweatinesses1546904sweat__inesses
tetchinesses1753554__tetchinesses
trashinesses1546114_tra_shinesses
worthinesses1845754wor_t_hinesses
archnesses1547175___arch_nesses
artinesses10815195_ar_t__inesses
artsinesses1138705_ar_t_sinesses
ashinesses1339155___a_shinesses
battinesses13169445__bat_tinesses
braininesses1446545_bra_ininesses
brashnesses1646545_bra_sh_nesses
brassinesses1346055_bra_ssinesses
brawninesses1744705_bra_wninesses
butchnesses1843685__butch_nesses
caginesses13310935_c_a__ginesses
cakinesses16310605_c_a__kinesses
campinesses1737115_c_a_mpinesses
canninesses1368855_c_a_nninesses
charinesses1639565_cha__rinesses
churchlinesses2451385_churchlinesses
clamminesses1873795_cla_mminesses
classinesses1366115_cla_ssinesses
cockinesses1947555_c__ockinesses
costlinesses1446245_cost_linesses
crabbednesses2072935_crabbednesses
crassnesses1246655_cra__ssnesses
cravennesses1744105_cra_vennesses
creakinesses1845985_cr_eakinesses
creaminesses1646125_cr_eaminesses
creativenesses1967015_creativenesses
creepinesses1645255_cr_eepinesses
crispinesses1645005_cr_ispinesses
criticalnesses1853125_criticalnesses
crumblinesses1952885_crumblinesses
crumminesses1843655_cr_umminesses
crunchiness1843285_crunchine_s_s
crustinesses14137595_cr_ustinesses
cushinesses16127405_c__ushinesses
dilatorinesses1552055dilatorinesses
dirtinesses1239875dir_t__inesses
draftinesses1645745_dra_ftinesses
earthlinesses1643905ear_thlinesses
fancinesses1638145__fanc_inesses
fattinesses14118975__fat_tinesses
filthinesses1844465_filt_hinesses
flashinesses18124865_fla_shinesses
gauchenesses1843315__gauchenesses
graininesses1346585_gra_ininesses
graphicnesses2151835_gra_phicnesses
grapinesses1438565_gra__pinesses
grittinesses1345835_grit_tinesses
growthinesses2042605_growthinesses
healthinesses1942965_healthinesses
heartinesses1547995heart__inesses
iratenesses11411405_irat__enesses
lacinesses12312105__la_c_inesses
lengthinesses1752145lengt_hinesses
loathnesses1445855_loat_h_nesses
lucrativenesses2054355lucrativenesses
marchionesses2052365__marchionesses
marshinesses1744965__marshinesses
matinesses12314525__mat__inesses
meatinesses13311975_meat__inesses
nattinesses11119315__nat_tinesses
patchiness1744935__patchine_s_s
paunchinesses2042335_paunchinesses
pithinesses1637505__pit_hinesses
portlinesses1446975por_t_linesses
prettinesses1447515_pret_tinesses
raininesses11310475__ra_ininesses
rancidnesses1544885__rancidnesses
randinesses121311205__ra_ndinesses
ranginesses121210115__ra_nginesses
rashnesses1338715__ra_sh_nesses
raspinesses1338005__ra_spinesses
richnesses1537795__r_ich_nesses
ritzinesses2096745__rit_zinesses
rockinesses1737355__r_ockinesses
ruttinesses11128975__rut_tinesses
saintlinesses1344365saint_linesses
saltinesses11311445s__a_ltinesses
salutarinesses1462775salutarinesses
sandinesses12911395s__a_ndinesses
sappinesses1567565s__a_ppinesses
sassinesses999315s__a_ssinesses
savorinesses1544605s__avorinesses
savvinesses1735665s__a_vvinesses
scantnesses1376535sc_a__ntnesses
scrappiness1752285scra_ppine_s_s
scratchers1744285scratch__e__rs
scratches1647315scratch_____es
scratchier1744335scratchi____er
scratching1844535scratchin____g
scrawniness1652155scra_wnine_s_s
scrutinises1363305scrut__in_ises
scurvinesses1743925sc__urvinesses
seaminesses13310755s_ea__minesses
secretivenesses2055665secretivenesses
sedatenesses1346945sedat__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
slacknesses1745235s_la_c_knesses
slanginesses1346965s_la_nginesses
sleazinesses2145375slea__zinesses
slushinesses1445465s__lushinesses
smarminesses1645105s_ma_rminesses
smartnesses1337145smart___nesses
smoothnesses1762655smoot_h_nesses
smuttinesses14135085s_mut_tinesses
snakinesses1538555s_na__kinesses
snappinesses1684325s_na_ppinesses
sneakinesses1645905snea__kinesses
snootinesses1265795snoot__inesses
snottinesses1255835s_not_tinesses
soapinesses1339705s_oa__pinesses
solitarinesses1452965solitarinesses
sootinesses11410045s_oot__inesses
sorrinesses11310085sor___rinesses
spicinesses1547095s__pic_inesses
sportinesses1447865sport__inesses
spottinesses1445685s_pot_tinesses
springinesses16104065spr_inginesses
sprucenesses1694615spr_uc_enesses
squatnesses2045185squat___nesses
squishinesses2442905s_quishinesses
staginesses1238465s___taginesses
starchiness1643945s_tarchine_s_s
staunchnesses1851465staunch_nesses
steadinesses1346905stea__dinesses
steaminesses1446225stea__minesses
stickinesses1845075s__tickinesses
stockinesses1844495s__tockinesses
stoninesses1138255s___toninesses
straitnesses1246205stra__itnesses
strandednesses1652815strandednesses
strangenesses1454955stra_ngenesses
streakinesses1743625str_eakinesses
strictnesses1445405str_ic_tnesses
stringinesses14124535str_inginesses
subacidnesses1851675suba_cidnesses
suchnesses1536655s___uch_nesses
sultrinesses1245885s_ult_rinesses
surlinesses11310045sur___linesses
swampinesses1943715s_wa_mpinesses
swankinesses1944785s_wa_nkinesses
swarthiness1743385swart_hine_s_s
swartnesses1436715swart___nesses
tackinesses1737255__ta_ckinesses
tartinesses111011495tar_t__inesses
tattinesses11128945__tat_tinesses
throatinesses1653265throat__inesses
touchinesses1744235__touchinesses
trickinesses1845215_tr_ickinesses
wackinesses2036655__wa_ckinesses
washinesses1737255__wa_shinesses
waterinesses1567195__waterinesses
wealthinesses1942625_wealthinesses
wretchednesses2351495_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.1261418182.5
2DLD Change Limit950242097.36012910.9
3Display Results2092090.1401492.9
 (SQL Overall)1786912097.62623431.8
 
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.