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

151 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
drape8531963(None) 
crape96128441crape
drake104918301drake
draped105314361draped
draper94315691draper
drapes95419651drapes
drapey125010581drapey
drave95219271drave
drupe85012991drupe
grape84824661grape
rape65041631_rape
agape85614842agape
ape57251182__ape
arame75026622arame
bedrape1277692bedrape
brace95629272brace
brae65639112bra_e
brake116025342brake
brave104925502brave
braze165423452braze
cape87242782_cape
chape125221142chape
crake114823522crake
crane75331602crane
crap85731842crap_
craped116120522craped
crapes104727692crapes
craps95328642craps
crate76537402crate
crave105626312crave
craze165221462craze
crepe95520722crepe
cripe95521142cripe
dace76934922d_ace
dale55643982d_ale
dame77140312d_ame
dap66652452d_ap_
daps77239162d_aps
dare55848862d_are
date56443322d_ate
daze147327232d_aze
deave95022332deave
derate74531232derate
diaper94513112diaper
dope76038892d_ope
drab76226452dra_b
drabs85119672drabs
draff125615662draff
draft95526682draft
drag64825052dra_g
dragee84415602dragee
drags75521112drags
drail65020972drail
drain65222892drain
drakes114715862drakes
dram75832002dra_m
drama85117412drama
drams86025832drams
drank104816202drank
drapers105313352drapers
drapery13387942drapery
drat56247832dra_t
drats66628372drats
draw85623012dra_w
drawee104413822drawee
drawer104711362drawer
drawl95516012drawl
drawn95614242drawn
draws95119372draws
dray85428092dra_y
drayed115911392drayed
drays95819772drays
dree56638322dr_ee
drip76223952drip_
drips85417232drips
dript86923872dript
drive95318002drive
drone65324982drone
drop75324402drop_
drops85719502drops
dropt86924432dropt
drove95518062drove
drupes94912652drupes
druse64817662druse
dupe76630602d_upe
erase54925492erase
etape74413702etape
frae75330472fra_e
frame105821802frame
frap95925812frap_
frappe13286952frappe
fraps105620552fraps
gape75134512_gape
grace85124542grace
grade75126092grade
grapes95123122grapes
grapey126012302grapey
graph115315612graph
grapy115416432grapy
grate64932882grate
grave94624872grave
graze155820052graze
gripe84622962gripe
grope84821612grope
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
undrape1049332undrape
urare56322552urare
urase54624692urase
urate55432162urate
wrap96821972wrap_
wraps105617152wraps
wrapt105123182wrapt

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.330541487.9
2DLD Change Limit538001511.65632487.9
3Display Results1511510.0463282.6
 (SQL Overall)1786911512.03287938.5
 
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.