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

161 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
graze15582005(None) 
braze165423451braze
craze165221461craze
gaze145032411g_aze
glaze155418161glaze
grace85124541grace
grade75126091grade
grape84824661grape
grate64932881grate
grave94624871grave
grazed174115911grazed
grazer164815761grazer
grazes164519641grazes
raze135235431_raze
agaze156113662agaze
agrafe1038092agrafe
amaze166016602amaze
arame75026622arame
blaze165520832blaze
brace95629272brace
brae65639112bra_e
braize174113112braize
brake116025342brake
brave104925502brave
braza165214252braza
brazed184717082brazed
brazen174812452brazen
brazer174917532brazer
brazes175522192brazes
crake114823522crake
crane75331602crane
crape96128442crape
crate76537402crate
crave105626312crave
crazed184714452crazed
crazes174720132crazes
crazy195511222crazy
croze164719452croze
daze147327232_daze
drake104918302drake
drape85319632drape
drave95219272drave
erase54925492erase
faze165630042_faze
feaze175216312feaze
frae75330472fra_e
frame105821802frame
froze174515652froze
gae46457702g_a_e
gage65936102g_age
gale56347322g_ale
game76644322g_ame
gane55145302g_ane
gape75134512g_ape
garage8314512garage
gate55746572g_ate
gauze155712972gauze
gave84634052g_ave
gazed165520332g_azed
gazer155720072g_azer
gazes155425912g_azes
ghazi1837442ghazi
glace87420162glace
glade75121962glade
glare65222962glare
glazed174711772glazed
glazer164212262glazer
glazes165315642glazes
glazy187410982glazy
gloze154815982gloze
graal64316502graal
grab75427612gra_b
graben9419722graben
grabs85719692grabs
graced105217902graced
graces94523492graces
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
grazers175112452grazers
grazier173611132grazier
grease75416232grease
greave104611492greave
grebe85114942grebe
gree56641562gr_ee
gride75223582gride
grime85021322grime
gripe84622962gripe
grope84821612grope
grosze16457732grosze
grove95219332grove
grue55825712gr_ue
grume86218162grume
gyrase10508772gyrase
gyrate104912522gyrate
haze164833392_haze
irade65618152irade
irate55627982irate
laze136235052_laze
maze155434982_maze
orate55133302orate
prase76128752prase
prate75135982prate
prize164718942prize
race66746262_race
rage55742352_rage
rake84841572_rake
rale45050562_rale
rape65041632_rape
rare45348432_rare
rase46149982_rase
rate45458762_rate
rave75542092_rave
razed155027982_razed
razee145827802_razee
razer144824272_razer
razes145032702_razes
razz125219422_razz
smaze165012932smaze
trace75829612trace
trade65026042trade
trave85223032trave
urare56322552urare
urase54624692urase
urate55432162urate

Search took 3 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 Limit538001611.79629955.5
3Display Results1611610.0463500.0
 (SQL Overall)1786911612.15582919.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.