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

80 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
jauntiness174397(None) 
daintiness1145962daintiness
faultiness1344822faultiness
gauntness1044202gaunt_ness
jauntiest1635492jaunti_est
jauntinesses1944682jauntinesses
runtiness92410392_runtiness
antsiness937843_a_ntsiness
artiness81615403_a_rtiness
aunties73920073_aunti_e_s
bandiness122310243ba_ndiness
battiness11239843ba_ttiness
bluntness1144343blunt_ness
bustiness111810473_bustiness
canniness1138643ca_nniness
cattiness112310633ca_ttiness
crustiness1237293crustiness
dauntless1033663daunt_less
dustiness102211033_dustiness
faintness1235833faint_ness
fanciness1437673fa_nciness
fattiness12239373fa_ttiness
flintiness1345893flintiness
fruitiness1345993fruitiness
funkiness16226873_funkiness
funniness12256533_funniness
fustiness121910243_fustiness
gaudiness1136253gau_diness
gauziness1934613gau_ziness
goutiness1038763gou_tiness
gustiness10189893_gustiness
handiness132110933ha_ndiness
hastiness122410883ha_stiness
haughtiness1842233haughtiness
jaundices1942183jaundice_s
jauntier1535233jaunti_e_r
jaunting16328633jauntin__g
jazziness2432843ja_zziness
jettiness1675693j_ettiness
juiciness1835153j_uiciness
jumpiness2034293j_umpiness
justness1535323j_ust_ness
lankiness1338053la_nkiness
lustiness92010453_lustiness
maltiness112910573ma_ltiness
manginess122010413ma_nginess
manliness111310123ma_nliness
matiness102114753ma__tiness
mustiness112211663_mustiness
nastiness92310573na_stiness
nattiness9239333na_ttiness
naughtiness1542383naughtiness
nuttiness9207563_nuttiness
pastiness112312353pa_stiness
paunchiness1842343paunchiness
puniness101610273_pun_iness
punkiness15226983_punkiness
raininess949273rain_iness
randiness102511443ra_ndiness
ranginess101610213ra_nginess
raunchiness1642883raunchiness
runniness9247103_runniness
rustiness92111933_rustiness
ruttiness9258793_ruttiness
saintliness1144153saintliness
saltiness93312113sa_ltiness
sandiness102111713sa_ndiness
sauciness1138043sau_ciness
scantiness1236883scantiness
smuttiness1244403smuttiness
spunkiness1644173spunkiness
sunniness9247943_sunniness
tanginess10239283ta_nginess
tartiness92112053ta_rtiness
tastiness92311143ta_stiness
tattiness9239413ta_ttiness
tautness8217183tau_t_ness
tawniness1245123tawn_iness
trustiness1036653trustiness
zaniness1738663za_n_iness

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 Filter1786911406030.423422437.4
2DLD Change Limit140603806.11023011.9
3Display Results80800.0302666.7
 (SQL Overall)178691806.56327227.0
 
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.