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

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

139 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
greys9661485(None) 
gleys96514851gleys
grays95621331grays
grees65132471grees
grey85624041grey_
preys105717781preys
treys85018211treys
agrees74915322agrees
areas55935772areas
ares45871022are_s
beys913829552_beys
brays106723112brays
brees75632552brees
brens75823362brens
brews105617072brews
creds85418772creds
cress75022832cress
crews105917502crews
deys85027472_deys
drays95819772drays
drees65628522drees
dregs76114862dregs
dreks105714752dreks
dress65319832dress
drys86314802dr_ys
egress73310432egress
egrets72712242egrets
fleys117015602fleys
frays116920102frays
frees86131392frees
frets85523402frets
gaes56348032gae_s
garveys14124462garveys
gays87338022g_ays
geds66730812g_eds
geeks104915842geeks
gees55647882g_ees
gels56836102g_els
gems75329112g_ems
gens55740072g_ens
germs85118872germs
gets55442482g_ets
gey75738302g_ey_
ghees95215552ghees
gies55641422gie_s
gleds75417892gleds
glees65027592glees
glens66519852glens
gley85724652gley_
goers65520252goers
goes55644092goe_s
gores65740372gore_s
goys86328412g_oys
grabs85719692grabs
grads75625752grads
grams85327312grams
grans64832542grans
grass66125202grass
gray85329892gray_
grease75416232grease
greasy10419462greasy
great66034242great
greats76318392greats
grebe85114942grebe
grebes93813612grebes
gree56641562gre_e
greed75125692greed
greeds84314282greeds
greek105915942greek
green65522142green
greens75716872greens
greet65835322greet
greets75117422greets
grego7310522grego
gregos847532gregos
grew85620262gre_w
greyed114610602greyed
greyer104510092greyer
greyest11348342greyest
greyish1435172greyish
greyly13316542greyly
grids75321392grids
griefs10418722griefs
grigs75318192grigs
grins65427222grins
grips85520132grips
grits65529582grits
grogs76319412grogs
groks105716122groks
gross65421692gross
grots65025852grots
grows95523922grows
grubs86312602grubs
gruels73910152gruels
grues65721962grues
guess64213362guess
gurneys11406462gurneys
guys85019642g_uys
gyres94820322gyre_s
ires45639282ire_s
joeys15518042joeys
keys116322162_keys
leys76430182_leys
obeys107010642obeys
ogres65818632ogre_s
ogress7529502ogress
ores46056682ore_s
prays105022432prays
prees75937172prees
preps96220692preps
press75425952press
prey96228482prey_
queys17398362queys
rays77642352_rays
rebs65733562_rebs
recs65734182_recs
reds56042862_reds
rees45364192_rees
refs75732242_refs
regs55436572_regs
reis45343232_reis
rems66237722_rems
reps65937952_reps
res35565042_re_s
rets45352562_rets
revs75027052_revs
ryes75529352_ryes
trays85623432trays
trees55835762trees
treks96016852treks
tres46542902tre_s
tress55423162tress
trets55928022trets
trews86118892trews
trey77228792trey_
troys86418612troys
ureas55826012ureas
wheys145911552wheys
wrens85016242wrens

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001391.39038705.0
3Display Results1391390.0304633.3
 (SQL Overall)1786911391.733103110.8
 
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.