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

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

160 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
gruffier154470(None) 
gruffer1475791gruff_er
buffier1568402_buffier
chuffier1934542chuffier
draffier1574322draffier
fluffier13264332fluffier
gauffer1474422gauff_er
grubbier13344752grubbier
gruffed1544942gruff_ed
gruffiest1634532gruffiest
gruffily1863082gruffily
gruffing1635272gruffing
gruffish1843942gruffish
grumpier1334802grumpier
grungier1034982grungier
gulfier1137792g_ulfier
huffier1637492_huffier
puffier1547972_puffier
ruffler13369722_ruffler
rufflier1434012_rufflier
scruffier1743302scruffier
snuffier14276942snuffier
stuffier14336622stuffier
argufier1242113argufier
bluffer15396883bluff_er
brushier13306973brushier
buffer144512683_buff_er
chaffier1935473chaffier
chuffer18337143chuff_er
cliffier1633913cliffier
craftier1376193craftier
crucifer1543683crucifer
crucifier1644313crucifier
cruddier1244153cruddier
crumbier1456363crumbier
crummier1435603crummier
crustier10259533crustier
daffier1457833_daffier
draftier1285263draftier
driftier1275123driftier
druggier11134833druggier
drumfire1442543drumfire
drumlier1134523drumlier
duffer134711663_duff_er
fluffer12336503fluff_er
fruitier1136593fruitier
frumpier1534173frumpier
gaffer134310133g_aff_er
gasifier1236273gasifier
gaudier938453gau_dier
gauffers1563833gauff_ers
gauzier1735633gau_zier
gluier7310263glu__ier
glumpier1334873glumpier
goffer13409513g_off_er
goofier11339313g_oofier
goutier82612353gou_tier
grabbier13316653grabbier
graffiti1542983graffiti
graffito1542873graffito
grafter114211153gr_after
grainier9218903grainier
grapier103712603gr_apier
grassier9349283grassier
gratifier1345823gratifier
grazier173611133gr_azier
greasier9298083greasier
greedier1036083greedier
greenier938713greenier
griffe13438093griff_e_
griffes14367923griff_es
griffin1434513griffi_n
griffins1544783griffins
grifter113810493gr_ifter
grimier103210433gr_imier
gripier103210323gr_ipier
grippier1355203grippier
grislier935793grislier
grittier9316263grittier
grodier939673gr_odier
groggier1134343groggier
groovier1233793groovier
grottier9316673grottier
grouchier1543843grouchier
groutier9297173groutier
growlier1234883growlier
grubber12417913gru_bber
grudger10368313gru_dger
grueler837023gru_eler
grueller935333grueller
gruff124712143gruff___
gruffest1544593gruffest
gruffly17413893gruff_ly
gruffness1692743gruffness
gruffs13337453gruff__s
gruffy16396013gruff__y
grumbler13866683grumbler
grummer12338783gru_mmer
grunger9389783gru_nger
grunter83110783gru_nter
grushie1135813grushie_
gulpier1046953g_ulpier
gummier12349473g_ummier
gunfire1134743g_unfire
gunkier12369553g_unkier
gushier113110073g_ushier
gustier83813863g_ustier
gutsier8389823g_utsier
guttier83911103g_uttier
iffier1236763__iffier
miffier1537023_miffier
muffler15398343_muffler
proffer15126933proff_er
puffer144610733_puff_er
purifier1338573purifier
raffler13339223_raffler
reefier102912553_reefier
reifier103414523_reifier
riffler13328353_riffler
rubier84814743_ru_bier
ruddier9338523_ruddier
ruffe114713813_ruff_e_
ruffed134312743_ruff_ed
ruffes124112423_ruff_es
ruffian1344133_ruffian
ruffing143210843_ruffing
ruffle124111673_ruffle_
ruffled14369153_ruffled
rufflers14347193_rufflers
ruffles133512273_ruffles
rulier65016353_ru_lier
rummier11309563_rummier
runnier74010113_runnier
runtier73512853_runtier
rushier103411973_rushier
rustier74416363_rustier
ruttier73412283_ruttier
scuffer15328883scuff_er
scuffler16286703scuffler
scurfier13267053scurfier
shuffler17306803shuffler
sniffier14356643sniffier
snuffer13318853snuff_er
snuffler14317413snuffler
snufflier1543303snufflier
spiffier16255883spiffier
squiffier2442843squiffier
stuffer13349793stuff_er
suffer124314513_suff_er
sufficer16225823_sufficer
surfier102613543_surfier
troffer13125863troff_er
truffe1276233truff_e_
truffes1356773truff_es
truffle1384893truffle_
truffled1563993truffled
truffles1485593truffles
trustier8268683trustier
tuftier1096603_tuftier
turfier10249793_turfier

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621606.21623513.8
3Display Results1601600.0632539.7
 (SQL Overall)1786911606.68526730.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.