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

171 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
greenly1140819(None) 
greenfly1554081greenfly
greeny104811451green_y
freely12310962free_ly
greatly1137612greatly
greedily1345182greedily
greedy11518852gree_dy
green65522142green__
greened93111262greened
greener83111712greener
greenery12265922greenery
greenie8310122greenie
greenlet948512greenlet
greenlit945802greenlit
greens75716872green_s
greenth11116722greenth
greenway1543852greenway
greyly13316542gr_eyly
keenly1336372_keenly
queenly1944462queenly
agreeably1543293agreeably
alienly1037503alienly
ardency1346483ardency
ardently1247453ardently
areally10411243areally
barrenly1345423barrenly
brazenly2263833brazenly
breezily2243653breezily
breezy20295853bree_zy
briefly1534573briefly
brokenly1744203brokenly
cheerly15417603cheerly
cleanly1236323cleanly
cravenly1644663cravenly
creel75121483cree_l_
creels84416943cree_ls
creepily1574953creepily
creepy13418803cree_py
crenel84213063crenel_
crenels93711013crenels
cruelly1236563cruelly
deeply1257013_deeply
eely77725213__ee_ly
erectly1257483erectly
evenly1236993_evenly
feebly1436653_feebly
fleetly1336323fleetly
freckly19124593freckly
freeway1635603freeway
frenzy2135883fr_enzy
freshly16286833freshly
friendly1544383friendly
frozenly2343123frozenly
gainly1049323g_ainly
gamely124711913game_ly
geeky134710733g_ee_ky
gently103710913g_ently
gerent73223103geren_t
gerents82612923gerents
gerenuk1243843gerenuk
gleety10479193glee_ty
glegly1134873g_legly
goldenly1344103goldenly
gorbelly1445473gorbelly
gorgedly1444003gorgedly
grainy103914213grain_y
grandly1238743grandly
granny104311163gr_anny
gravelly15385773gravelly
gravely14469063gravely
grayly13287963gr_ayly
greasily1236233greasily
greasy10419463gr_easy
gree56641563gree___
greed75125693gree__d
greeds84314283gree_ds
greeing93613783greeing
greek105915943gree__k
greenbelt1243973greenbelt
greenbug1242633greenbug
greenest9312623greenest
greenier938713greenier
greenies9312673greenies
greening103112533greening
greenish1247083greenish
greenlets1044703greenlets
greenling1136753greenling
greenths1295213greenths
greenways1643433greenways
grees65132473gree__s
greet65835323gree__t
greeted93111383greeted
greeter82812673greeter
greets75117423gree_ts
gremmy1454473gr_emmy
grey85624043gr_e__y
grimily1336523grimily
grimly12459933gr_imly
grisly104310583gr_isly
gristly11187333gristly
grizzly19354473grizzly
grossly1175983grossly
growly13499173gr_owly
gruel66014743grue_l_
gruels73910153grue_ls
gruffly17413893gruffly
grumbly15355403grumbly
grungy11345973gr_ungy
leanly93811503_leanly
meanly115412043_meanly
meekly1535193_meekly
meetly1138673_meetly
merely111312593mere_ly
openly1137123_openly
orderly1135763orderly
preen75925053preen__
preened103214993preened
preener93114833preener
preens85020113preen_s
presently1449063presently
pronely12310253pronely
provenly1646203provenly
queerly1934233queerly
really93315613_really
recency1438633_recency
recently1339423_recently
redeny102712733_reden_y
redly94217203_r_edly
reechy14367823_reechy
reedily1179613_reedily
reedy910020293_ree_dy
reefy114217703_ree_fy
reeky125416263_ree_ky
reel45240533_ree_l_
reels55333263_ree_ls
reenjoy1743293_reenjoy
reentry1038033_reentry
refly113914563_r_efly
regency1337363_regency
rely75428953_r_e_ly
reply104015853_r_eply
seely84522633_see_ly
seemly1138433_seemly
serenely1147623serenely
sheeney13398933sheeney
sheeny124912193sheen_y
sheerly13337703sheerly
sleekly14325193sleekly
steely93612573stee_ly
steeply1236293steeply
sternly1037853sternly
sweeney13387003sweeney
sweeny12358843sween_y
sweetly1335593sweetly
teensy9478273_teensy
teeny85417883_teen_y
thegnly1442613thegnly
treacly1237093treacly
trebly1138973tr_ebly
treen55622753treen__
treens65317873treen_s
trembly1435523trembly
trendy10469603tr_endy
tweeny12477003tween_y
unevenly1444613unevenly
urgency1345663urgency
urgently1245623urgently
vixenly2043193vixenly
weekly1635313_weekly
weensy12416823_weensy
weeny115316163_ween_y

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.420425454.8
2DLD Change Limit1340271717.04619021.7
3Display Results1711710.0632714.3
 (SQL Overall)1786911717.52923733.7
 
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.