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

180 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
wraps10561715(None) 
craps95328641craps
fraps105620551fraps
raps66247731_raps
traps75727481traps
waps96642081w_aps
warps107126421warps
whaps135115161whaps
wrap96821971wrap_
wrapt105123181wrapt
araks94820882araks
ataps76414832ataps
baps86040842_baps
bewraps14135402bewraps
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
bras65746452bra_s
brass75428022brass
brats75336012brats
braws106425192braws
brays106723112brays
caps87147892_caps
carps96932252carps
chaps125326062chaps
claps95626182claps
crabs95421392crabs
crags85622572crags
cramps125615562cramps
crams96229152crams
crap85731842crap_
crape96128442crape
crapes104727692crapes
crass76328042crass
craws105723122craws
crops96125232crops
daps77239162_daps
drabs85119672drabs
drags75521112drags
drams86025832drams
drape85319632drape
drapes95419652drapes
drats66628372drats
draws95119372draws
drays95819772drays
drips85417232drips
drops85719502drops
enwraps1284832enwraps
eras45441502era_s
flaps105621382flaps
frags96322162frags
frap95925812frap_
frass85321122frass
frats86829672frats
frays116920102frays
gaps76042972_gaps
grabs85719692grabs
grads75625752grads
gramps114114272gramps
grams85327312grams
grans64832542grans
grape84824662grape
grapes95123122grapes
graph115315612graph
graphs124510152graphs
grapy115416432grapy
grasp84814482grasp
grasps9489252grasps
grass66125202grass
grays95621332grays
grips85520132grips
haps96443462_haps
harps105926862harps
heaps105223222heaps
inwraps12105252inwraps
knaps115511172knaps
laps66848872_laps
leaps75522932leaps
maps86141042_maps
naps66238582_naps
neaps75618322neaps
orals55826482orals
paps86443452_paps
prams96125512prams
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
preps96220692preps
props95726882props
rads56046602_rads
rags55448372_rags
rais45252622_rais
ramps96224632_ramps
rams65950772_rams
rap56261962_rap_
rape65041632_rape
rapes75740722_rapes
rapt67245312_rapt
ras37575392_ra_s
rasp66029162_rasp
rasps74316662_rasps
rats46260372_rats
raws75238212_raws
rays77642352_rays
reaps75626192reaps
reps65937952_reps
rewraps12136562rewraps
rips66237432_rips
saps65346372_saps
scraps106017242scraps
slaps76025712slaps
snaps74719562snaps
soaps75120712soaps
straps87721782straps
swaps104819202swaps
taps66050672_taps
tarps76527112tarps
tramps105114452tramps
trams75327672trams
trans54933042trans
trap67532802trap_
trapes85024462trapes
trapt76433392trapt
trass56226472trass
trays85623432trays
trips74923362trips
unwraps1255512unwraps
urps66920472ur_ps
wabs97337232w_abs
wads87343142w_ads
waes76048602w_aes
wags86140552w_ags
wans76452262w_ans
wap86553372w_ap_
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warp95635002warp_
wars78659802w_ars
warts814840402warts
was68767562w_a_s
wasp95626852w_asp
wasps106714692wasps
wataps11248682wataps
wats77555882w_ats
waws106834902w_aws
ways107737952w_ays
weals85428742weals
weans85326742weans
wears86030302wears
weeps104120562weeps
whams135515642whams
whap125119642whap_
whats117718992whats
whaups14405752whaups
whips134917082whips
whops135013932whops
whups134210002whups
wimps125213802wimps
wisps105214182wisps
woads94818442woads
woops104917522woops
wops96634152w_ops
wrack145413882wrack
wracks154711112wracks
wrang94716112wrang
wrangs104611912wrangs
wrasse9398772wrasse
wrath115715872wrath
wraths123810082wraths
wreaks134711112wreaks
wrens85016242wrens
wries85827742wries
writs86624382writs
yaps95933522_yaps
zaps156826892_zaps

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.0931921408.6
2DLD Change Limit538001802.54621131.2
3Display Results1801800.0931935.5
 (SQL Overall)1786911802.73265406.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.