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

183 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
gelcap113621(None) 
gelcaps1235201gelcaps
becap114315052be_cap
beleap10410282beleap
recap95718022re_cap
redcap1158492redcap
becaps123811403be_caps
beclasp1335263beclasp
belay105021523bel_ay
belch124415503belc_h
beldam11410113beldam
beleaps1138053beleaps
beleapt11310253beleapt
belga8313233belga_
belgas9311713belgas
bewrap13157053bewrap
calcar10312753calcar
cap76758983___cap
ceca84820783ce_ca_
cecal94619113ce_cal
celiac101910433celiac
cella75420313cella_
cellae84915933cellae
cellar84514983cellar
cercal10314123cercal
clap86429043_cl_ap
decaf114919443de_caf
decal85523233de_cal
decamp1338453de_camp
decay114718483de_cay
declaw1266703declaw
delay94820633del_ay
delead84112343delead
delta66117773delta_
deltas74414823deltas
dewlap1264843dewlap
eclat7523603_eclat
eggcup1241833eggcup
elan46734243_el_an
encamp1235943_encamp
escape103811663_escape
escar74011993_escar
escarp10449003_escarp
fecal105119213fe_cal
fella84918653fella_
fellah124910773fellah
fellas95116963fellas
flap96128703_fl_ap
gala55635163gal_a_
galah95917643gal_ah
galas65731643gal_as
galax135314463gal_ax
galea64722943galea_
galeae74717453galeae
galeas74618513galeas
gallop93311383gallop
galop84716223gal_op
galyac1235973galyac
galyak1445333galyak
gap67055613g___ap
gear55934973ge__ar
geck115721993ge_c_k
gecko124511113ge_cko
gecks125117093ge_cks
geegaw1142853geegaw
gel45642433gel___
gelada837623gelada
geladas936313geladas
gelant72821673gelant
gelate73421263gelate
gelati73814533gelati
gelato73812963gelato
geld65828433gel__d
gelded94512113gelded
gelder84613713gelder
gelds75118343gel_ds
gelee63626983gel_ee
gelees74116263gelees
gelid74916983gel_id
gellant83214053gellant
gelled84718893gelled
gels56836103gel__s
gelt56448013gel__t
gelts65924613gel_ts
gemma106311773gemma_
gemmae11507793gemmae
genial74917613genial
genip84415203ge_nip
genipap1243123genipap
genoa64315823genoa_
genoas74013623genoas
genua64614153genua_
gerah9315303ge_rah
german9611993german
gestapo1044493gestapo
geta56627443ge_ta_
getas65421483ge_tas
getup83410263ge_tup
gewgaw1441783gewgaw
giddap1143413giddap
glace87420163g_lace
glad65624013g_l_ad
glam76529343g_l_am
gleam86916733g_leam
glean65818203g_lean
gleba83910243gleba_
glebae9407613glebae
glia56423153g_lia_
glial66715433g_lial
glias64618493g_lias
gloam86015943g_loam
gloat65427683g_loat
glop76724633g_l_op
glucan936183glucan
glycan1234903glycan
gulag7310823gul_ag
gular6314833gul_ar
gulch113810603gulc_h
gulp75521363gul__p
heap96432893he__ap
heeltap1243733heeltap
heliac111010893heliac
helical12311153helical
hellcat12410173hellcat
help95328923hel__p
hepcat13611823hepcat
hubcap1554003hubcap
icecap1245223icecap
jalap143612473jal_ap
kelep116014563kel_ep
kelp105322813kel__p
kneecap1542303kneecap
lap58565273__l_ap
leap66032683__leap
madcap1336333madcap
mecca1139933mecca_
meccas1239493meccas
mescal104113493mescal
mezcal19367853mezcal
midcap1336473midcap
mobcap1444113mobcap
mudcap1335133mudcap
neap66927013ne__ap
oilcamp1343053oilcamp
oilcan837793oilcan
oilcup1044253oilcup
pecan91919033pe_can
pelican1139433pelican
petnap1037423petnap
reap65934743re__ap
recaps103615733re_caps
reclad9311873reclad
reclasp1136643reclasp
redcaps1247073redcaps
relace83122153relace
relax124817803rel_ax
relay84424673rel_ay
reload7413893reload
reloan6415693reloan
remap95418103re_map
rewrap11127533rewrap
selah8319613sel_ah
selva83014273selva_
selvas93812913selvas
skycap1742913skycap
slap66434043_sl_ap
sulcal8311283sulcal
teacup1036253teacup
tela45532973tel_a_
telae54323293tel_ae
telco7511873telc_o
telcos8710683telcos
telia55821143telia_
telial65815363telial
toecap1037323toecap
uncap9312283_uncap
upleap10106843upleap
vela75725543vel_a_
velar85817633vel_ar
velcro1144133velcro
webcam1545543webcam
welch134411493welc_h
yelp95621353yel__p

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.373479064.3
2DLD Change Limit1127161835.42320784.8
3Display Results1831830.0463978.3
 (SQL Overall)1786911835.84230587.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.