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 “redcap” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

274 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
redcap115849(None) 
recap95718021re_cap
redcaps1247071redcaps
becap114315052be_cap
gelcap1136212gelcap
madcap1336332madcap
midcap1336472midcap
mudcap1335132mudcap
reap65934742re__ap
recaps103615732re_caps
redact9419042redact
redan66125012red_an
redbay1238332redbay
redcoat10410882redcoat
redear73515172redear
redia65524482redia_
rediae74221992rediae
redial74923112redial
redias74523602redias
redip87816962red_ip
redraw10269852redraw
redtop937972redtop
remap95418102re_map
rewrap11127532rewrap
areca75618633are_ca_
arecas84817443are_cas
becaps123811403be_caps
bedlam1149273bedlam
bedlamp1464513bedlamp
bedpan1137583bedpan
bedrape1277693bedrape
beleap10410283beleap
bewrap13157053bewrap
cap76758983___cap
ceca84820783ce_ca_
cecal94619113ce_cal
cedar84014323ced_ar
cercal10314123cercal
credal9311673cred_al
dap66652453__d_ap
decaf114919443de_caf
decal85523233de_cal
decamp1338453de_camp
decay114718483de_cay
dedal75719023ded_al
dewlap1264843dewlap
encamp1235943_encamp
erica7316543erica_
ericas8315463ericas
escape103811663_escape
escar74011993_escar
escarp10449003_escarp
fecal105119213fe_cal
gelcaps1235203gelcaps
giddap1143413giddap
heap96432893he__ap
hepcat13611823hepcat
hubcap1553993hubcap
icecap1245223icecap
keddah1534273keddah
kidnap1334193kidnap
kneecap1542303kneecap
leap66032683le__ap
madcaps1435243madcaps
mecca1139933mecca_
meccas1239493meccas
medal86221333med_al
media84721713media_
mediad104313713mediad
mediae94217413mediae
medial93819863medial
median94117543median
medias93620783medias
medical12312513medical
medigap1374623medigap
medlar93010463medlar
mescal104113483mescal
mezcal19367853mezcal
mobcap1444113mobcap
mudcaps1444103mudcaps
mudcat11311203mudcat
neap66927013ne__ap
pecan91919033pe_can
pedal86022503ped_al
pedicab1446693pedicab
pedlar93311273pedlar
pedocal1237893pedocal
petnap1037423petnap
predial103815413predial
prewrap14104973prewrap
radar61316723rad_ar
radial74020393radial
radian74117273radian
radical103312793radical
rap56261963r___ap
rascal8511123rascal
reach105123883reac_h
react74634333reac_t
reacts83616603reacts
read55942533re__ad
readapt1039743readapt
real45750293re__al
ream65841613re__am
reaps75626193re__aps
rear45644553re__ar
reata54225393reata_
reatas64021013reatas
rebar75420193re_bar
rebop9313283re_bop
rec55645463re_c__
recall83815723re_call
recane83022873re_cane
recant83228683re_cant
recast83422773re_cast
recce9514563re_cce
recces10614913recces
recept103319073re_cept
recipe103414893re_cipe
recit75235103re_cit
reck106130563re_c_k
recks115625133re_cks
reclad9311873reclad
reclasp1136643reclasp
recoal84117973recoal
recoat84024273recoat
recon75624243re_con
recopy1339043re_copy
recoup10810373recoup
recs65734183re_c_s
recta74220263re_cta
rectal84418133rectal
recti73619623re_cti
recto74520803re_cto
recur74116843re_cur
recut74729243re_cut
red46755803red___
redacts10510943redacts
redans75421023redans
redate74124683redate
redbait1039803redbait
redbays1336013redbays
redbud10135803redbud
redbug10165473redbug
redcoats1147123redcoats
redd66323173red__d
redded94019553redded
redden83613623redden
redder83918143redder
reddle83815913reddle
redds74617833red_ds
rede55037673red__e
redears82814453redears
reded74829123red_ed
redeem9311533redeem
redefy13388763redefy
redeny102712733redeny
redes65139133red_es
redeye103811793redeye
redfin10310223redfin
redhead1257053redhead
redials84416883redials
redid74922393red_id
reding83825563reding
redips93713843redips
redipt94116743redipt
redleg839273redleg
redly94217203red_ly
redo56029363red__o
redock134311543redock
redocks14409933redocks
redoes74623763redoes
redon65424883red_on
redone74820053redone
redons75222183redons
redos65126763red_os
redout71820253redout
redowa1038453redowa
redowas1138393redowas
redox134714233red_ox
redraft11310573redraft
redrawn11245953redrawn
redraws11218473redraws
redream10107913redream
redrew10309513redrew
redry94314363red_ry
reds56042863red__s
redtail858713redtail
redtops1037373redtops
redub84212413red_ub
redubs9358383redubs
reduce9713253reduce
reduced11610323reduced
reducer1059003reducer
reduces10513343reduces
redux133811103red_ux
redware1139363redware
redye94413473red_ye
redyed114611243redyed
redyes104214093redyes
reecho11318653reecho
reechy14367823reechy
reedman1037723reedman
reface113616353reface
reflag1098083reflag
regal65023793re_gal
regear73512743regear
reggae858953reggae
regma84612333regma_
regna64614813regna_
regnal74812933regnal
rehab10312443re_hab
rehear93713223rehear
reheat94423943reheat
relace83122153relace
relax124817803re_lax
relay84424673re_lay
reload7413893reload
reloan6415693reloan
reman75730153re_man
remaps105012873re_maps
renal55929503re_nal
rental63922023rental
rep55847803re___p
repack142412163repack
repay104818453re_pay
repeal84718283repeal
repeat85127213repeat
replan83215823replan
replay113412923replay
repp85418743re__pp
repump1235683repump
rerack122513163rerack
reran57329103re_ran
reread71715433reread
resat55139683re_sat
resaw84117253re_saw
resay85320543re_say
rescale93215473rescale
rescue8313003rescue
reseal64819643reseal
reseat64131493reseat
reseau64216213reseau
reshape1249043reshape
reship11310673reship
resoak10311093resoak
restamp1146483restamp
retack122612823retack
retag63618413re_tag
retape83917683re_tape
retax124517973re_tax
retch104818303retc_h
reteam83214533reteam
retear63115483retear
retia55326113retia_
retial64724993retial
retral64419743retral
revamp1336013revamp
reveal94115053reveal
rewan85623663re_wan
rewax155713923re_wax
rewear93012003rewear
rewraps12136563rewraps
rewrapt12138113rewrapt
riprap1055513riprap
rodman949713rodman
rootcap1143973rootcap
sedan65620423sed_an
skycap1742913skycap
teacup1036253teacup
toecap1037323toecap
uncap9312283_uncap
uredia73610063uredia_
uredial82910483uredial
webcam1545543webcam

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162745.14021929.2
3Display Results2742740.0932946.2
 (SQL Overall)1786912745.62331778.6
 
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.