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 “scrappinesses” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
scrappinesses195229(None) 
sappinesses1567562s__appinesses
scrappiness1752282scrappine_s_s
scrawninesses1842422scrawninesses
snappinesses1684322s_nappinesses
campinesses1737113_c_ampinesses
choppinesses2143353_choppinesses
craftinesses1746373_craftinesses
cragginesses1644503_cragginesses
crankinesses1846143_crankinesses
crazinesses2237923_cra_zinesses
creepinesses1645253_creepinesses
crispinesses1645003_crispinesses
grapinesses1438563_gra_pinesses
happinesses1876163__happinesses
nappinesses1555923__nappinesses
preppinesses1544873_preppinesses
raspinesses1338003__raspinesses
scalinesses1339313sc_a_linesses
scantinesses1437313sc_antinesses
scarinesses1339903sc_a_rinesses
scratchinesses2151753scratchinesses
screwinesses1744743scr_ewinesses
scruffinesses2151563scruffinesses
sloppinesses1644053s_loppinesses
soapinesses1339703s_oa_pinesses
soppinesses1566843s__oppinesses
swampinesses1943713s_wampinesses
unhappinesses2052483unhappinesses
braininesses1446544_braininesses
brassinesses1346054_brassinesses
brattinesses1466254_brattinesses
brawninesses1744704_brawninesses
caginesses13310934_c_a_ginesses
cakinesses16310604_c_a_kinesses
canninesses1368854_c_anninesses
cattinesses13129704_c_attinesses
chancinesses1945034_chancinesses
charinesses1639564_cha_rinesses
chattinesses1755154_chattinesses
clamminesses1873794_clamminesses
classinesses1366114_classinesses
crassnesses1246654_cra_ssnesses
cravennesses1744104_cravennesses
creakinesses1845984_creakinesses
creaminesses1646124_creaminesses
crispnesses1545944_crisp_nesses
crumminesses1843654_crumminesses
crustinesses14137594_crustinesses
dippinesses1635244__dippinesses
draftinesses1645744_draftinesses
floppinesses1942954_floppinesses
graininesses1346584_graininesses
graphicnesses2151834_graphicnesses
grumpinesses1743664_grumpinesses
hippinesses1845494__hippinesses
lippinesses1535514__lippinesses
nippinesses1545064__nippinesses
peppinesses1435314__peppinesses
racinesses12313494__ra_cinesses
raininesses11310474__raininesses
randinesses121311204__randinesses
ranginesses121210114__ranginesses
rapidnesses1476464__rapidnesses
raptnesses1248524__ra_ptnesses
ropinesses121311014__r_opinesses
saltinesses11311444s__altinesses
sandinesses12911394s__andinesses
sappiness1337434s__appine_s_s
sassinesses999314s__assinesses
saucinesses1338954s__aucinesses
savvinesses1735664s__avvinesses
scantnesses1376534sc_a_ntnesses
scarcenesses1644494sc_arcenesses
scrappiest1644154scrappi_e_s_t
scrawniness1652154scrawnine_s_s
scurvinesses1743924sc_urvinesses
seaminesses13310754s_ea_minesses
shabbinesses1953434s_habbinesses
shadinesses1538644s_ha_dinesses
shagginesses1743964s_hagginesses
shakinesses1837614s_ha_kinesses
shapelinesses1843414s_hapelinesses
sharpnesses1645234s_harp_nesses
skimpinesses2043184s_kimpinesses
slanginesses1346964s_langinesses
slatinesses11311614s_la_tinesses
sleazinesses2145374slea_zinesses
sleepinesses1445674s_leepinesses
smarminesses1645104s_marminesses
snakinesses1538554s_na_kinesses
snappiness1443824s_nappine_s_s
snappishnesses2052264s_nappishnesses
sneakinesses1645904snea_kinesses
sorrinesses11310084sor__rinesses
spacinesses1538094s_pa_cinesses
splashinesses1742734splashinesses
springinesses16104064springinesses
squashinesses2442354squashinesses
staginesses1238464s_ta_ginesses
starchinesses1843214starchinesses
steadinesses1346904stea_dinesses
steaminesses1446224stea_minesses
straitnesses1246204stra_itnesses
strangenesses1454954strangenesses
straplesses1353284stra_p_lesses
streakinesses1743624streakinesses
stringinesses14124534stringinesses
surlinesses11310044sur__linesses
swankinesses1944784s_wankinesses
swarthinesses1943454swarthinesses
sweatinesses1546904swea_tinesses
trashinesses1546114_trashinesses
waspinesses1636694__waspinesses

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 Filter178691950240.1101624463.6
2DLD Change Limit950241146.50014619.1
3Display Results1141140.0801425.0
 (SQL Overall)1786911146.69026710.2
 
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.