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

151 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
churchlinesses245138(None) 
churchliness2251602churchline_s_s
courtlinesses1544453cour_tlinesses
crunchinesses2052853crunch_inesses
curlinesses1338723c_ur__linesses
burlinesses1338394_bur__linesses
chancinesses1945034chanc__inesses
charinesses1639564char___inesses
chillinesses1744984ch__illinesses
chubbinesses2142604chu__bbinesses
chumminesses2142864chu__mminesses
churchless20112494churchl__e_s_s
churchliest2152364churchli_e_s_t
churlishnesses2252544churlishnesses
crumblinesses1952884cru_mblinesses
curablenesses17146954c_urablenesses
cursorinesses1553284c_ursorinesses
cushinesses16127404c_u_sh_inesses
earthlinesses1643904_earthlinesses
paunchinesses2042334paunch_inesses
raunchinesses1842624raunch_inesses
starchinesses1843214starch_inesses
surlinesses11310044_sur__linesses
touchinesses1744234tou_ch_inesses
achinesses1539295___ach_inesses
archnesses1547175__arch__nesses
bitchinesses1943515_bitch_inesses
blurrinesses1484105blur__rinesses
bushinesses16107455_bu_sh_inesses
butchnesses1843685_butch__nesses
chattinesses1755155ch__attinesses
cheekinesses2164205ch__eekinesses
cheerfulnesses2253385cheerful_nesses
cheerinesses1765825ch__eerinesses
cheesinesses1765375ch__eesinesses
chewinesses1945145ch___ewinesses
chicnesses1745205ch_ic___nesses
chillnesses1644715ch___illnesses
choicenesses1944665choic__enesses
choppinesses2143355ch__oppinesses
churchianities247825churchianities
churchiest2044055church_i_e_s_t
churchings2162555church_in___gs
churchlier2052265churchli____er
circularnesses1861415c_ircularnesses
cleanlinesses1553885c_leanlinesses
clubbinesses1843155clu__bbinesses
clumsinesses1644755clu__msinesses
cockinesses1947555c__oc_kinesses
coercivenesses2165635coercivenesses
comelinesses1666395c__omelinesses
comradelinesses2061395comradelinesses
corkinesses1749205c_or__kinesses
corninesses13410585c_or__ninesses
costlinesses1446245c__ostlinesses
courtliness1343905cour_tline_s_s
cowardlinesses2052515cowardlinesses
craftinesses1746375c__raftinesses
cragginesses1644505c__ragginesses
crankinesses1846145c__rankinesses
crazinesses2237925c__r_azinesses
creakinesses1845985c__reakinesses
creaminesses1646125c__reaminesses
creepinesses1645255c__reepinesses
crispinesses1645005c__rispinesses
crotchetinesses2261085crotchetinesses
cruelnesses1346245c__ruel_nesses
crumminesses1843655c__rumminesses
crunchiness1843285crunch_ine_s_s
crustinesses14137595c__rustinesses
curiousnesses1548985c_uriousnesses
curliness1138555c_ur__line_s_s
currentnesses1552985c_urrentnesses
cursednesses1554965c_ur_sednesses
cursivenesses1847465c_ursivenesses
curtnesses1238365c_ur___tnesses
doughtinesses1852545dou_ghtinesses
durablenesses16156545_durablenesses
earlinesses11311035_ear__linesses
earthinesses1545815_earth_inesses
furrinesses1437175_fur__rinesses
gauchenesses1843315gau_ch_enesses
ghastlinesses1742745gh_astlinesses
ghostlinesses1742495gh_ostlinesses
grislinesses1345825__grislinesses
grouchinesses1942655grouch_inesses
growlinesses1644725__growlinesses
gushinesses15127015_gu_sh_inesses
hardinesses151110215_har__dinesses
harshnesses1745855_harsh__nesses
haughtinesses2042165_haughtinesses
hillinesses1458505_h__illinesses
holinesses13511485_h___olinesses
homelinesses1765355_h_omelinesses
horninesses1458995_hor__ninesses
horsinesses1439535_hor__sinesses
huffinesses2034115_hu__ffinesses
humblenesses1944955_hu_mblenesses
humpinesses18106235_hu__mpinesses
hungrinesses1643855_hu_ngrinesses
hurriednesses1752855_hurriednesses
hurtfulnesses1954825_hurtfulnesses
huskinesses18136525_hu__skinesses
itchinesses1644605__itch_inesses
juicinesses2035865_juic__inesses
lordlinesses1345155_lor_dlinesses
luckinesses1746635_lu_c_kinesses
marchionesses2052365_marchionesses
marshinesses1744965_marsh_inesses
muchnesses1744695_mu_ch__nesses
murkinesses17136775_mur__kinesses
mushinesses16127315_mu_sh_inesses
naughtinesses1752405nau_ghtinesses
patchinesses1944365_patch_inesses
pluckinesses2043985plu_c_kinesses
plushinesses1744715plu_sh_inesses
portlinesses1446975_por_tlinesses
preachinesses2043745preach_inesses
pricklinesses2143615_pricklinesses
princelinesses1892715princelinesses
pursinesses1338725_pur__sinesses
pushinesses1697325_pu_sh_inesses
queenlinesses2252275_queenlinesses
saucinesses1338955sau_c__inesses
scalinesses1339315___scalinesses
scratchinesses2151755scratch_inesses
scurvinesses1743925scur__vinesses
shapelinesses1843415sh_apelinesses
shrillnesses1543495sh_r_illnesses
sicklinesses1844855__sicklinesses
sketchinesses2251885sketch_inesses
slouchinesses1842805slouch_inesses
slushinesses1445465slu_sh_inesses
squashinesses2442355squash_inesses
squishinesses2442905squish_inesses
sturdinesses1345795stur__dinesses
suchnesses1536655_su_ch__nesses
swarthinesses1943455swarth_inesses
tetchinesses1753555_tetch_inesses
thirstinesses1642585thir_stinesses
thorninesses1544395thor__ninesses
threadinesses1753335th_readinesses
thriftinesses1952305th_riftinesses
throatinesses1653265th_roatinesses
uglinesses1138535__u__glinesses
unearthlinesses1861855unearthlinesses
unholinesses1544905__unholinesses
unrulinesses1245805__unrulinesses
worldlinesses1752805_worldlinesses
worthinesses1845755_worth_inesses
yuckinesses2044745_yu_c_kinesses

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.1231452772.4
2DLD Change Limit950241517.65612411.7
3Display Results1511510.1101372.7
 (SQL Overall)1786911517.88922650.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.