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

259 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
traps7572748(None) 
craps95328641craps
fraps105620551fraps
raps66247731_raps
straps87721781straps
taps66050671t_aps
tarps76527111tarps
tramps105114451tramps
trams75327671trams
trans54933041trans
trap67532801trap_
trapes85024461trapes
trapt76433391trapt
trass56226471trass
trays85623431trays
trips74923361trips
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
entraps9109762entraps
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
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
rips66237432_rips
saps65346372_saps
satraps95011642satraps
scraps106017242scraps
slaps76025712slaps
snaps74719562snaps
soaps75120712soaps
strap77925262strap_
strass67117222strass
straws98718672straws
strays96417932strays
streps86218062streps
strips85719652strips
strops86220382strops
swaps104819202swaps
tabs66842982t_abs
tads57143942t_ads
tags55545232t_ags
tamps95524082tamps
tams67247932t_ams
tans46154812t_ans
taos45541002t_aos
tap57663872t_ap_
tapa65129142t_apa
tapas74627712t_apas
tape64538142t_ape
tapes75838602t_apes
tapis75028862t_apis
tares57456562tares
tarns56433952tarns
taros55640822taros
tarp66936412tarp_
tars46763952t_ars
tarts57242022tarts
tas38477102t_a_s
tass45640572t_ass
tats46858132t_ats
taus46342732t_aus
tavs75630972t_avs
taws75641592t_aws
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492tea_s
teats55636812teats
temps95417132temps
tepas76521682tepas
terais64023502terais
teraph11319092teraph
thaws116515462thaws
thraws129211102thraws
threaps12488642threaps
thrips11299012thrips
tips66436762t_ips
toads65621072toads
tops66248122t_ops
torahs95115642torahs
toras55540372tora_s
trace75829612trace
traces85329932traces
track114823012track
tracks124818842tracks
tract75635712tract
tracts85019072tracts
trad55630912tra_d
trade65026042trade
trades75724502trades
tragi64717172tragi
tragus749232tragus
traik95418202traik
traiks104013712traiks
trail55126772trail
trails64622512trails
train56529112train
trains64725342trains
traipse935872traipse
trait56940842trait
traits65121982traits
tram67034552tra_m
tramp96319772tramp
trampy13499252trampy
trank96222422trank
tranks104017762tranks
tranq145416892tranq
tranqs155210312tranqs
trapan82412972trapan
trapans92812462trapans
trash86119762trash
trave85223032trave
traves94222742traves
trawl84915872trawl
trawls94412392trawls
tray77632592tra_y
treads74817922treads
treats64821692treats
trees55835762trees
treks96016852treks
tres46542902tr_es
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
triacs83913222triacs
triads74513532triads
trials64319882trials
tries55742812tries
trigs65423062trigs
trims75021472trims
trios55528092trios
trip66830392trip_
tripe75425382tripe
tripes85324872tripes
tripos84014922tripos
troaks104410602troaks
trogs67022602trogs
trois57226092trois
tromps104911702tromps
troops85712782troops
trop66833302trop_
trope75725802trope
tropes84824352tropes
trots56629942trots
trows88826182trows
troys86418612troys
trues54925322trues
trugs65516802trugs
trumps104611882trumps
truss54916922truss
tsars56717102tsars
tumps95420792tumps
tups65628762t_ups
turps74918732turps
twaes86513662twaes
twas76824082twa_s
twats86616602twats
typps12549302typps
tzars144914272tzars
urps66920472ur_ps
waps96642082_waps
warps107126422warps
whaps135115162whaps
wrap96821972wrap_
wrapt105123182wrapt
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.1231452772.4
2DLD Change Limit538002591.98627089.6
3Display Results2592590.0604316.7
 (SQL Overall)1786912592.16982384.0
 
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.