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

188 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
gemmate1241838(None) 
gemmae11507791gemma_e
gemmated14336291gemmated
gemmates13307671gemmates
agemate101210582age_mate
bedmate1239432bedmate
fermate122813002fermate
gelate73421262ge_late
geminate11411812geminate
gemma106311772gemma__
gemmule12173232gemmule
gemote94613022ge_mote
germane1049662germane
gestate83614072gestate
gummata1244612gummata
gummite1236132gummite
lemmata1144672lemmata
mammate104411272mammate
remate84428682re_mate
summate113611662summate
teammate1245612teammate
aerate64830553ae_rate
agemates111110033age_mates
animate91617213animate
bedmates1349193bedmates
bemata10411693be_mata
berate84729023be_rate
bregmate1345543bregmate
bromate11313553bromate
cellmate1237873cellmate
cerate84829463ce_rate
climate11312833climate
comate104124843_comate
commata1338483commata
commute134310443commute
cremate113816183cremate
crewmate15405633crewmate
dealate83617843dealate
debate94419193de_bate
decimate13411123decimate
deflate113613943deflate
delate73827753de_late
demote94817803de_mote
dentate8315153dentate
derate74531233de_rate
deviate11312723deviate
elate55335883_e_late
eluate62315433_eluate
emanate9312473_emanate
emeute838533_emeute
emirate91015833_emirate
emmet94221383_emmet_
emmets10349153_emmets
emote75421193_e_mote
empale102611263_empale
emulate9314123_emulate
enate54428153_e_nate
equate152012463_equate
ergate7315143_ergate
estate64719763_estate
fellate10313433fellate
female11310553fe_male
femme125011433femm__e
fermata12278143fermata
ferrate103014043ferrate
formate123115093formate
galeate83916793galeate
gallate83417133gallate
gambade1336383gambade
gamete9313593g_amete
gamma106116113gamma__
gammas115714703gamma_s
gate55746573g___ate
gelated93615643ge_lated
gelates83219593ge_lates
gelati73814533ge_lati
gelato73812963ge_lato
geminated1338553geminated
geminates12310043geminates
gemlike14206813gemlike
gemmating1576443gemmating
gemmation1445963gemmation
gemmed12329573gemm_ed
gemmier12337383gemmier
gemmily1534603gemmily
gemming13289153gemming
gemmules13183213gemmules
gemmy135211053gemm__y
gemot84024233ge_mot_
gemotes103712143ge_motes
gemots93712153ge_mots
generate9312903generate
genette838863genette
geometer1138423geometer
german9611993germa_n
germans1079473germans
germinate1248633germinate
gestated102910573gestated
gestates93213733gestates
geste65920693ge__ste
gimmal11247513gimma_l
gimmals12225823gimmals
gimme102411343gimm__e
gimmie11298183gimm_ie
globate1057823globate
gradate9511233gradate
grate64932883g__rate
gremmie1264383gremm_ie
grimace1255083grimace
gumma105313103gumma__
gummas114810513gumma_s
gummites1346173gummites
gummose1235333gummose
guttate8328903guttate
gyrate104912523g_yrate
hamate113319833_hamate
helpmate1545603helpmate
hermae115314483herma_e
humate113214443_humate
imamate1138103imamate
immane1038883_immane
inmate82917363_inmate
legate72917453le_gate
lemma94811033lemma__
lemmas10349163lemma_s
lemmatize2245563lemmatize
limbate1139213limbate
mammae94613223mamma_e
mammati10398373mammati
mate65154223___mate
mediate103415213mediate
messmate1246393messmate
metate82720533me_tate
mismate111415353mismate
negate72915573ne_gate
neonate7311333neonate
nervate1039533nervate
palmate113215233palmate
pectate112214693pectate
pedate93117763pe_date
peltate92013773peltate
pennate93314033pennate
permeate12311613permeate
permute1138793permute
plumate1149803plumate
primate111516283primate
ramate83921693_ramate
rebate84424113re_bate
recrate92621663recrate
redate74124683re_date
reflate103516263reflate
regmata1036193regmata
regrate82618663regrate
reimage1037913reimage
relate64033633re_late
remade94316983re_made
remake124016113re_make
remated103522473re_mated
remates93827123re_mates
remote84222603re_mote
replate93420053replate
reslate73520593reslate
restate73824883restate
roommate1244863roommate
rummage1234583rummage
seatmate1048573seatmate
sedate73019813se_date
semimat11412913semimat_
semimatt1258313semimatt
semimatte1354733semimatte
semimute1245513semimute
senate63725173se_nate
sensate7311893sensate
septate9511873septate
seriate73722473seriate
serrate73017543serrate
sigmate10710143sigmate
stemmata1244213stemmata
stomate9313123stomate
summae103911013summa_e
summated13298833summated
summates122610493summates
teammates1345673teammates
template1238433template
termite9313893termite
ternate7415483ternate
testate73916233testate
velate93720143ve_late

Search took 8 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 Filter1786911340270.403443402.0
2DLD Change Limit1340271886.70619986.1
3Display Results1881880.0603133.3
 (SQL Overall)1786911887.16924925.5
 
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.