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

90 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
prettiness125739(None) 
pettiness1178701p_ettiness
brattiness1255842brattiness
grittiness1145162grittiness
jettiness1675692_jettiness
pottiness1179702p_ottiness
preppiness1344422preppiness
pretties10615132pretti_e_s
prettiest1199802pretti_est
prettinesses1447542prettinesses
ruttiness9258792_ruttiness
artiness81615403ar__tiness
artsiness937653ar_tsiness
battiness11239843_battiness
bittiness11228333_bittiness
breathiness1644323breathiness
breeziness2143513breeziness
cattiness112310633_cattiness
chattiness1565123chattiness
craftiness1545753craftiness
creakiness1645963creakiness
creaminess1446203creaminess
creatines112814433creatine_s
creepiness1444883creepiness
crustiness1237293crustiness
dottiness1058043_dottiness
draftiness1444863draftiness
dreaminess1345313dreaminess
dreariness1146283dreariness
dressiness1145543dressiness
erectness1146123erect_ness
fattiness12239373_fattiness
freakiness1745183freakiness
frettiest1267063fretti_est
frostiness1336563frostiness
frothiness1645723frothiness
fruitiness1345993fruitiness
greasiness1156543greasiness
greatness1036903great_ness
greediness1245833greediness
heftiness1536313_heftiness
knottiness1483593knottiness
meatiness11311183_meatiness
nattiness9239333_nattiness
nuttiness9207563_nuttiness
paltriness1244993paltriness
pastiness112312353p_astiness
pectines121914683p_ectine_s
peppiness1235183p_eppiness
perkiness15209163p_erkiness
pertness10310093p_ert_ness
peskiness15216523p_eskiness
petiteness1248493p_etiteness
pettiest103113963p_etti_est
pettinesses1338633p_ettinesses
pettings11349703p_ettin_gs
pettishness1643973p_ettishness
pithiness1437563p_ithiness
portliness1246833portliness
preachiness1844283preachiness
preattunes1243973preattune_s
prentices131111903prentice_s
prerinses1138813pre_rinses
prestiges12310593prestige_s
prestress1138133prest_ress
pretenses112210593pre_tenses
prettied1159253pretti_e_d
prettier1069043pretti_e_r
prettifiers1642513prettifiers
prettifies1545693prettifies
priestliness1452923priestliness
prissiness1266133prissiness
prosiness11311683pr_osiness
readiness102611853_readiness
reediness10239613_reediness
retainers92510763_retainers
retines75134673_re_tine_s
ritziness1835823_ritziness
rootiness979063_rootiness
runtiness92410393_runtiness
rustiness92111933_rustiness
smuttiness1244403smuttiness
snottiness1055593snottiness
spottiness1285763spottiness
sweatiness1336463sweatiness
tattiness9239413_tattiness
testiness9209753_testiness
trendiness1146223trendiness
trustiness1036653trustiness
wittiness12197223_wittiness

Search took 9 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.440406115.9
2DLD Change Limit140603907.95017685.9
3Display Results90900.0501800.0
 (SQL Overall)178691908.44021171.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.