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

212 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
gristly1118733(None) 
bristly12178061bristly
grisly104310581gris_ly
gristle8169221gristle
briskly16165402briskly
bristle91910102bristle
brittly12165972brittly
crisply14426522crisply
firstly1335642firstly
garishly1545692garishly
ghastly14354562ghastly
ghostly14355102ghostly
greatly1137612greatly
grimily1336522grimily
grimly12459932gri_mly
grist65529872grist__
grister83915412grister
gristles9189202gristles
grists74716482grist_s
grittily1244182grittily
gritty10338402gri_tty
grizzly19354472grizzly
grossly1175982grossly
moistly1236612moistly
ogrishly1544032ogrishly
priestly1345842priestly
thistly1395962thistly
wristy12509702wrist_y
aguishly1543613aguishly
apishly1535663apishly
aridly105513703ari_dly
arista6415293arist_a
aristae7312533aristae
aristas7413523aristas
aristo6414033arist_o
aristos7312373aristos
artistry1144453artistry
beastly1277563beastly
brashly15427613brashly
briefly1534573briefly
brightly1764553brightly
bristled11187343bristled
bristles101510433bristles
bristol937043bristol
bristols1046773bristols
brittle9168603brittle
christy1536623christ_y
costly114012333_costly
crassly1276653crassly
crinkly16387523crinkly
crispily1574693crispily
crispy13478563cris_py
crista8311803crist_a
cristae9310613cristae
crossly1277273crossly
crusily12199093crusily
crustily13328173crustily
crusty114911343crust_y
dribbly15274953dribbly
drifty13418223drift_y
drily95816523dri__ly
drizzly19364553drizzly
epistle957893epistle
erectly1257483erectly
eristic9814093eristic
erosely1038083erosely
faintly1337083faintly
feistily1445263feistily
feisty12449293feist_y
fitly115114973_fi_tly
freshly16286833freshly
friarly13316213friarly
frilly124111443fri_lly
friskily1834503friskily
frisky16406673fris_ky
frizzly21455793frizzly
frostily1436693frostily
frosty124710633frost_y
gaiety10119373gaiet_y
gaily95020973gai__ly
gainly1049323gai_nly
gassily1137813gassily
gauntly1135333gauntly
gently103710913g_ently
ghosty13467213ghost_y
giggly12518703g_iggly
gilly94321633g_i_lly
girlishly1642863girlishly
girly94415293g_i_rly
gist56046763g_ist__
gists66026193g_ist_s
glibly1236293gli_bly
glinty106910693glint_y
glisten8418083glisten
glister84013343glister
glitzy19404783gli_tzy
gorily10612503gori__ly
grandly1238743grandly
grassily1236433grassily
grassy10619093gras_sy
gravely14469063gravely
grayly13287963gr_ayly
greasily1236233greasily
greenly11408193greenly
greyly13316543gr_eyly
gribble12297273gribble
griddle1035503griddle
grift95924463grift__
grifted12379583grifted
grifter113810493grifter
grifts104511683grift_s
grill64617893gri__ll
grille74315743gri_lle
grills74314803gri_lls
grimy114312603gri__my
griot65328413griot__
griots74713643griot_s
gripey124111203gri_pey
gripple12416613gripple
grippy14447763gri_ppy
gript85126173gript__
gripy115115253gri__py
grisette994653grisette
griskin1236013griskin
grison7310103gris_on
grisons838993grisons
gristers94013403gristers
gristlier1044283gristlier
gristmill1261703gristmill
grit55247243gri_t__
grith95520373gri_t_h
griths105211653gri_ths
grits65529583gri_t_s
gritted94110903gritted
gritter83913353gritter
grizzle16306113grizzle
groszy19395703gros_zy
grotty10389833gr_otty
grouty104710983grout_y
growly13499173gr_owly
growthy1773283growthy
gruffly17413893gruffly
grumbly15355403grumbly
gruntle8257053gruntle
guiltily1243423guiltily
guilty10418233guilt_y
gustily113010903g_ustily
gusty95119573g_ust_y
gutsily11267223gutsily
hostly124210863_hostly
istle52214713__istle
jointly1735483jointly
justly16307253_justly
lastly93310873_lastly
mistily122612343_mistily
misty106120453_mist_y
mostly113110943_mostly
noisily1038403noisily
ogreishly1642523ogreishly
pricily142710283pricily
prickly18367893prickly
primely1457723primely
primly13439623pri_mly
priorly12335763priorly
prissily1346693prissily
prissy11347853pris_sy
privily15207623privily
prosily12611633prosily
quietly1945893quietly
raptly11338913_raptly
rashly123410213_rashly
rattly94111543_rattly
riantly1037613_riantly
richly1438003_richly
rifely123710033_rifely
rightly14389043_rightly
ripely112511153_ripely
ripply13348003_ripply
risibly1235643_risibly
riskily1436413_riskily
risky126311523_ris_ky
ristra6310713_ristra
ritzy175611163_ri_tzy
rosily93914713_rosily
rustily103112993_rustily
rustle63615413_rustle
rusty85221053_rust_y
saintly1039343saintly
strictly1345813strictly
swiftly1633733swiftly
thistle10107803thistle
trestle72611363trestle
trickly16369893trickly
trigly103810943tri_gly
trimly114410893tri_mly
triply114211023tri_ply
trisomy1235943trisomy
triste63818643trist_e
tritely1039003tritely
trustily11257103trustily
trusty94710113trust_y
twisty12426863twist_y
vastly12508723_vastly
whistle13107533whistle
wisely122711713_wisely
wrastle10368993wrastle
wrestle10298843wrestle
wriggly15324893wriggly
wrinkly17295753wrinkly
wrist84827563wrist__
wristlet1138643wristlet
wrists95415643wrist_s

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272126.65620136.3
3Display Results2122120.0932279.6
 (SQL Overall)1786912127.15524974.3
 
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.