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

197 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
grape8482466(None) 
crape96128441crape
drape85319631drape
gape75134511g_ape
grace85124541grace
grade75126091grade
grapes95123121grapes
grapey126012301grapey
graph115315611graph
grapy115416431grapy
grate64932881grate
grave94624871grave
graze155820051graze
gripe84622961gripe
grope84821611grope
rape65041631_rape
agape85614842agape
agrafe1038092agrafe
ape57251182__ape
arame75026622arame
brace95629272brace
brae65639112bra_e
brake116025342brake
brave104925502brave
braze165423452braze
cape87242782_cape
chape125221142chape
crake114823522crake
crane75331602crane
crap85731842crap_
craped116120522craped
crapes104727692crapes
craps95328642craps
crate76537402crate
crave105626312crave
craze165221462craze
crepe95520722crepe
cripe95521142cripe
drake104918302drake
draped105314362draped
draper94315692draper
drapes95419652drapes
drapey125010582drapey
drave95219272drave
drupe85012992drupe
erase54925492erase
etape74413702etape
frae75330472fra_e
frame105821802frame
frap95925812frap_
frappe13286952frappe
fraps105620552fraps
gae46457702g_a_e
gage65936102g_age
gale56347322g_ale
game76644322g_ame
gane55145302g_ane
gap67055612g_ap_
gaped96123532g_aped
gaper86125122g_aper
gapes86030822g_apes
gaps76042972g_aps
gapy106320912g_apy
garage8314512garage
gate55746572g_ate
gave84634052g_ave
gaze145032412g_aze
glace87420152glace
glade75121962glade
glare65222952glare
glaze155418162glaze
graal64316502graal
grab75427612gra_b
graben9419722graben
grabs85719692grabs
graced105217902graced
graces94523492graces
grad66829862gra_d
graded94919552graded
grader84919692grader
grades84926312grades
grads75625752grads
graft95327202graft
grail64622872grail
grain65126252grain
gram77034582gra_m
grama85620282grama
gramme114210332gramme
gramp106218322gramp
grampa115010172grampa
gramps114114272gramps
grams85327312grams
gran56335012gra_n
grana65722092grana
grand75122692grand
grange83716202grange
grans64832542grans
grant64840022grant
grapery13457952grapery
graphed1498472graphed
graphs124510152graphs
grapier103712602grapier
grapnel1035602grapnel
grappa11396442grappa
grapple12378002grapple
grasp84814482grasp
grasped11409062grasped
grasper10389792grasper
grasps9489252grasps
grass66125202grass
grat55651282gra_t
grated84523922grated
grater74625442grater
grates75429892grates
graupel1034132graupel
graved114818812graved
gravel105313822gravel
graven104513522graven
graver105018592graver
graves104624002graves
gravy125512112gravy
gray85329892gra_y
grayed115415642grayed
grayer106014542grayer
grays95621332grays
grazed174115912grazed
grazer164815762grazer
grazes164519642grazes
grease75416232grease
greave104611492greave
grebe85114942grebe
gree56641562gr_ee
gride75223582gride
grime85021322grime
grip76127022grip_
griped104114712griped
griper94114612griper
gripes94619872gripes
gripey124111202gripey
grippe115310322grippe
grips85520132grips
gript85126172gript
gripy115115252gripy
groped107515052groped
groper94517252groper
gropes95220402gropes
grove95219332grove
grue55825712gr_ue
grume86218162grume
gyrase10508772gyrase
gyrate104912522gyrate
irade65618152irade
irate55627982irate
jape134923422_jape
nape65230802_nape
orate55133302orate
prase76128752prase
prate75135982prate
race66746262_race
rage55742352_rage
rake84841572_rake
rale45050562_rale
rap56261962_rap_
raped85334622_raped
raper74932752_raper
rapes75740722_rapes
raphe104916422_raphe
raps66247732_raps
rapt67245312_rapt
rare45348432_rare
rase46149982_rase
rate45458762_rate
rave75542092_rave
raze135235432_raze
ripe66038922_ripe
rope65542912_rope
sarape84817572sarape
scape96921842scape
scrape105917572scrape
serape84818412serape
shape105125112shape
tape64538142_tape
trace75829612trace
trade65026042trade
trap67532802trap_
trapes85024462trapes
traps75727482traps
trapt76433392trapt
trave85223032trave
tripe75425382tripe
trope75725802trope
urare56322552urare
urase54624682urase
urate55432162urate
wrap96821972wrap_
wraps105617152wraps
wrapt105123182wrapt

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.0931921408.6
2DLD Change Limit538001971.39038705.0
3Display Results1971970.0464282.6
 (SQL Overall)1786911971.529116867.9
 
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.