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

193 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
fraps10562055(None) 
craps95328641craps
flaps105621381flaps
frags96322171frags
frap95925811frap_
frass85321121frass
frats86829671frats
frays116920101frays
raps66247731_raps
traps75727481traps
wraps105617151wraps
araks94820882araks
ataps76414832ataps
baps86040842_baps
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
eras45441502era_s
fabs98635862f_abs
fads86939872f_ads
fags86939122f_ags
fans76247372f_ans
farads104713272farads
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
fas68262932f_a_s
fats76252502f_ats
fays108535362f_ays
fears84829392fears
feats86432752feats
ferals94216642ferals
fiars86720832fiars
fiats85324482fiats
flabs105818642flabs
flags95321282flags
flams105125012flams
flans85327972flans
flap96128702flap_
flats86429742flats
flaws115920342flaws
flays116321052flays
flips105117742flips
flops105920142flops
foals85721692foals
foams105017952foams
fops96532682f_ops
forams115115912forams
forays124813002forays
fracas11311992fracas
frae75330472fra_e
frag85126272fra_g
frail85220212frail
frails93716472frails
fraise94214912fraise
frame105821802frame
frames115119862frames
franc104615412franc
francs114112192francs
frank124417512frank
franks134912732franks
frappe13286952frappe
frappes14328382frappes
frat75648542fra_t
fraud939862fraud
frauds1036752frauds
fray105428902fra_y
freaks134713062freaks
frees86131392frees
frets85523402frets
friars93812092friars
fries85535602fries
frigs96019272frigs
frits86129102frits
froes86126692froes
frogs96220772frogs
frons86124042frons
frows116623102frows
frugs96114282frugs
frumps13479782frumps
furans94515952furans
gaps76042972_gaps
grabs85719692grabs
grads75625752grads
gramps114114272gramps
grams85327312grams
grans64832542grans
grape84824662grape
grapes95123122grapes
graph115315612graph
graphs124510152graphs
grapy115416432grapy
grasp84814482grasp
grasps9489252grasps
grass66125202grass
grays95621332grays
grips85520132grips
haps96443462_haps
harps105926872harps
heaps105223222heaps
knaps115511172knaps
laps66848872_laps
leaps75522932leaps
maps86141052_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
rips66237432_rips
saps65346372_saps
scraps106017242scraps
slaps76025712slaps
snaps74719562snaps
soaps75120712soaps
straps87721782straps
swaps104819202swaps
taps66050672_taps
tarps76527112tarps
tramps105114452tramps
trams75327672trams
trans54933042trans
trap67532802trap_
trapes85024462trapes
trapt76433392trapt
trass56226472trass
trays85623432trays
trips74923362trips
urps66920482ur_ps
waps96642082_waps
warps107126422warps
whaps135115162whaps
wrap96821972wrap_
wrapt105123182wrapt
yaps95933522_yaps
zaps156826892_zaps

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.326548131.9
2DLD Change Limit538001931.54634799.5
3Display Results1931930.0464195.7
 (SQL Overall)1786911931.91893165.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.