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

100 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
brattiness125584(None) 
battiness11239841b_attiness
bittiness11228332b_ittiness
braininess1246122braininess
brassiness1235482brassiness
brattices1345552brattice_s
brattiest1148102bratti_est
brattinesses1466262brattinesses
brawniness1544032brawniness
breathiness1644322breathiness
cattiness112310632_cattiness
chattiness1565122chattiness
craftiness1545752craftiness
draftiness1444862draftiness
fattiness12239372_fattiness
grittiness1145162grittiness
nattiness9239332_nattiness
prettiness1257392prettiness
ruttiness9258792_ruttiness
tattiness9239412_tattiness
artiness81615403__artiness
artsiness937653ar_tsiness
bagginess1355953b_agginess
balkiness1556903b_alkiness
balminess1356593b_alminess
bandiness122310243b_andiness
batteners11238163b_atteners
battiest104115553b_atti_est
battinesses13169453b_attinesses
battings114010573b_attin_gs
bawdiness15235543b_awdiness
beadiness12249233bea_diness
beastliness1343333beastliness
bractless1335543bract_less
brainless1136403bra__inless
brashness1436323bra_shness
brattice1245693brattice__
bratticed1443283brattice_d
brattier1047663bratti_e_r
brattish1346973bratti__sh
brattles10199333bratt_le_s
braveness14237763bra_veness
brazenness2142883brazenness
breeziness2143513breeziness
brininess1138203br_ininess
brittleness1353733brittleness
broodiness1344653broodiness
bustiness111810473b_ustiness
cragginess1444143cragginess
crankiness1636173crankiness
craziness2037383cra_ziness
crustiness1237293crustiness
dottiness1058043_dottiness
earthiness1377243earthiness
franticness1643603franticness
frostiness1336563frostiness
frothiness1645723frothiness
fruitiness1345993fruitiness
graininess1145793graininess
grapiness1238253gra_piness
gratinees10307323gra_tinees
hastiness122410883_hastiness
heartiness1338033heartiness
irateness9310493ira_teness
jettiness1675693_jettiness
knottiness1483593knottiness
maltiness112910573_maltiness
matiness102114753_ma_tiness
meatiness11311183mea_tiness
nastiness92310573_nastiness
nuttiness9207563_nuttiness
pastiness112312353_pastiness
pettiness1178703_pettiness
pottiness1179703_pottiness
raciness102413453_ra_ciness
raininess949273_raininess
randiness102511443_randiness
ranginess101610213_ranginess
raptness1046733_rapt_ness
raspiness1137303_raspiness
ratines75328583_ra_tine_s
ratlines83815293_ratline_s
ratteners9237263_ratteners
rattiest83516113_ratti_est
ritziness1835823_ritziness
rootiness979063_rootiness
runtiness92410393_runtiness
rustiness92111933_rustiness
saltiness93312113_saltiness
scantiness1236883scantiness
slatiness92511363sla_tiness
smuttiness1244403smuttiness
snottiness1055593snottiness
spottiness1285763spottiness
tartiness92112053_tartiness
tastiness92311143_tastiness
trashiness1346443trashiness
trustiness1036653trustiness
wittiness12197223_wittiness
yeastiness1344883yeastiness

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.406440125.6
2DLD Change Limit1406031005.64024929.6
3Display Results1001000.0462173.9
 (SQL Overall)1786911006.09229332.1
 
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.