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

167 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
grace8512454(None) 
brace95629271brace
glace87420161glace
graced105217901graced
graces94523491graces
grade75126091grade
grape84824661grape
grate64932881grate
grave94624871grave
graze155820051graze
race66746261_race
trace75829611trace
ace59656832__ace
agrafe1038092agrafe
apace94718382apace
arame75026622arame
braced115420602braced
bracer104620582bracer
braces108427772braces
brach126123302brach
bract96332722bract
brae65639112bra_e
brake116025342brake
brave104925502brave
braze165423452braze
crack134120532crack
crake114823522crake
crane75331602crane
crape96128442crape
crate76537402crate
crave105626312crave
craze165221462craze
dace76934922_dace
drake104918302drake
drape85319632drape
drave95219272drave
erase54925492erase
face96140122_face
farce104925322farce
frae75330472fra_e
frame105821802frame
gae46457702g_a_e
gage65936102g_age
gale56347322g_ale
game76644322g_ame
gane55145302g_ane
gape75134512g_ape
garage8314512garage
gate55746572g_ate
gave84634052g_ave
gaze145032412g_aze
glaces94218032glaces
glade75121962glade
glance94312312glance
glare65222962glare
glaze155418162glaze
graal64316502graal
grab75427612gra_b
graben9419722graben
grabs85719692grabs
gracile102512602gracile
grackle14338892grackle
grad66829862gra_d
graded94919552graded
grader84919692grader
grades84926312grades
grads75625752grads
graft95327202graft
grail64622872grail
grain65126252grain
gram77034582gra_m
grama85620282grama
gramme114210332gramme
gramp106218322gramp
grams85327312grams
gran56335012gra_n
grana65722092grana
grand75122692grand
grange83716202grange
grans64832542grans
grant64840022grant
grapes95123122grapes
grapey126012302grapey
graph115315612graph
grapy115416432grapy
grasp84814482grasp
grass66125202grass
grat55651282gra_t
grated84523922grated
grater74625442grater
grates75429892grates
graved114818812graved
gravel105313822gravel
graven104513522graven
graver105018592graver
graves104624002graves
gravy125512112gravy
gray85329892gra_y
grayed115415642grayed
grayer106014542grayer
grays95621332grays
grazed174115912grazed
grazer164815762grazer
grazes164519642grazes
grease75416232grease
greave104611492greave
grebe85114942grebe
gree56641562gr_ee
gride75223582gride
grimace1255082grimace
grime85021322grime
gripe84622962gripe
grocer94212142grocer
grope84821612grope
grove95219332grove
grue55825712gr_ue
grume86218162grume
guaco85012162guaco
gyrase10508772gyrase
gyrate104912522gyrate
irade65618152irade
irate55627982irate
lace66848472_lace
mace87345792_mace
orach105219232orach
orache114013592orache
oracle84313292oracle
orate55133302orate
pace86345772_pace
peace95026082peace
place94824612place
prance104318572prance
prase76128752prase
prate75135982prate
price93725412price
raced87635312_raced
racer75233022_racer
races74943242_races
rack106234882_rack
racy95825682_racy
rage55742352_rage
rake84841572_rake
rale45050562_rale
rance75028512_rance
rape65041632_rape
rare45348432_rare
rase46149982_rase
rate45458762_rate
rave75542092_rave
raze135235432_raze
rice64942912_rice
space95325672space
tace65342512_tace
traced94821582traced
tracer84820232tracer
traces85329932traces
track114823012track
tract75635712tract
trade65026042trade
trance84718762trance
trave85223032trave
trice75127492trice
truce75118692truce
urare56322552urare
urase54624692urase
urate55432162urate
wrack145413882wrack

Search took 4 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 Limit538001673.25016553.8
3Display Results1671670.0463630.4
 (SQL Overall)1786911673.60949512.6
 
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.