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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

59 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
scarceness144476(None) 
sarcenets1146952s_arcenets
scarcenesses1644492scarcenesses
scariness11310182scar_iness
spareness1139862spar_eness
sparseness1245492sparseness
archness1337513__archness
awareness1236343awar_eness
bareness10912813_bar_eness
carcanets1347313_carcanets
careeners1138543_careeners
careless102813633_car_eless
coarseness1246173coarseness
fierceness1543793fierceness
hoarseness1345303hoarseness
larceners1135993_larceners
largeness1038273_largeness
parceners1337453_parceners
rareness81112853_rar_eness
sacredness1344543sacredness
safeness11239633s_a_feness
sageness92111983s_a_geness
sameness102712683s_a_meness
saneness82313723s_a_neness
sarcenet10413313s_arcene_t
sarsenets946513s_arsenets
sauciness1138043s_auciness
scaleless1135513sca_leless
scaliness1149303sca_liness
scantiness1236883scantiness
scantness1135733sca_ntness
scarcest12169173scarc__est
scaredest1246633scar_edest
scarless10189053scar__less
scatheless1542923scatheless
scoreless1155603scor_eless
screeners1136733sc_reeners
scurviness1543283scurviness
searchless1543373searchless
secureness1245053secur_eness
sharpeners1543893sharpeners
sharpness1434943shar_pness
slackness1535433sla_ckness
smarminess1444303smarminess
smartness1136143smar_tness
sorceress1144013s_orceress
soreness8914793s_or_eness
sourceless1273013sourceless
spaceless1335733spa_celess
spaciness1337083spa_ciness
spruceness1444103spruceness
squareness1944763squar_eness
stableness1248823stableness
staleness9310783sta_leness
starchiness1643943starchiness
starkness1335963star_kness
suaveness1247703sua_veness
sureness8912903s_ur_eness
swartness1236113swar_tness

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 Filter1786911406030.420425454.8
2DLD Change Limit140603597.19019555.4
3Display Results59590.0301966.7
 (SQL Overall)178691597.64023388.9
 
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.