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

244 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
gemmae1150779(None) 
gemma106311771gemma_
gemmate12418381gemmate
femme125011432femm_e
gamma106116102gamma_
gammas115714692gammas
gemmated14336292gemmated
gemmates13307672gemmates
gemmed12329572gemmed
gemmier12337382gemmier
gemmule12173232gemmule
gemmy135211052gemm_y
gemote94613022gemote
german9611982german
germane1049662germane
gimmal11247512gimmal
gimme102411342gimm_e
gimmie11298182gimmie
gremmie1264382gremmie
gumma105313102gumma_
gummas114810512gummas
hermae115314472hermae
lemma94811032lemma_
lemmas10349162lemmas
mammae94613212mammae
summae103911012summae
agemate101210583agemate
amebae1049633amebae
became123213163became
bedmate1239433bedmate
bema85825253be_ma_
bemas96424283be_mas
bemean10410683bemean
bemire103312803bemire
bemoan10310253bemoan
bemuse1038943bemuse
bename103316073bename
berme96022943berm_e
cammie124615293cammie
cellae84915933cellae
comae97128423_comae
comma114514793comma_
commas124814573commas
commie124215523commie
cymae126713013_cymae
dammar11438903dammar
defame123212433defame
degame102713183degame
deme76536283de_m_e
demean9510563demean
demise94618323demise
demode104013463demode
demote94817803demote
demure9311533demure
derma84918513derma_
dermal93614343dermal
dermas94116813dermas
desman9311693desman
embar94011603_embar
embay123410603_embay
emcee9315943_emcee
eme55837183_e_m_e
emmer94314463_emmer
emmet94221383_emmet
emmy116013243_emm_y
emmys12446023_emmys
emote75421193_emote
empale102611263_empale
emyde1136383_emyde
female11310553female
feme96130543fe_m_e
femmes135410213femmes
feriae95618603feriae
fermate122813003fermate
gae46457703g___ae
gagman103811243gagman
galeae74717453galeae
gama77035523g_ama_
gamas85431363g_amas
gamay116419113g_amay
gamba106018513gamba_
gambade1336383gambade
gambas115817513gambas
gambe106219213g_ambe
gamble115417183gamble
game76644323g_am_e
gamete9313593gamete
gamine94620153gamine
gammed124216163gammed
gammer1112318333gammer
gammier123711193gammier
gammon1138903gammon
gammy135514893gamm_y
gasman92911743gasman
gear55934973ge__ar
gee45359203ge___e
geegaw1142853geegaw
geese64316003ge_ese
gelate73421253gelate
gelcap1136213gelcap
gelee63626983ge_lee
gem66840223ge_m__
geminal10109913geminal
geminate11411813geminate
gemlike14206813gemlike
gemmiest13227633gemmiest
gemmily1534603gemmily
gemming13289153gemming
gemmules13183213gemmules
gemot84024233ge_mot
gemotes103712143gemotes
gemots93712153gemots
gems75329113ge_m_s
gene56237223ge__ne
genial74917613genial
genie66124923ge_nie
genoa64315823genoa_
genoas74013623genoas
genome94312193genome
genre66016803ge_nre
gentle74014513gentle
genua64614153genua_
geode7412593ge_ode
gerah9315303ge_rah
germ75428963germ__
germans1079473germans
germen9612313germen
germier10309543germier
germs85118873germ_s
germy115113663germ_y
gestate83614073gestate
geste65920693ge_ste
geta56627443ge_ta_
getas65421483ge_tas
geum75424553geum__
geums85414113geum_s
gewgaw1441783gewgaw
gimbal11228813gimbal
gimmals12225823gimmals
gimmes113010903gimmes
gimmies123010113gimmies
glebae9407613glebae
gleeman1035363gleeman
glime85620193glim_e
glume85120463glum_e
gnome84213953gnom_e
grama85620283grama_
gramas94317203gramas
gramma11499803gramma_
grammar12406893grammar
grammas12499773grammas
gramme114210333gramme
gremial1039153gremial
gremmies1355993gremmies
gremmy1454473gremm_y
grimace1255083grimace
grime85021323grim_e
grume86218163grum_e
guimpe1134723guimpe
gummata1244613gummata
gummed123811663gummed
gummer114615453gummer
gummier12349473gummier
gummite1236133gummite
gummose1235333gummose
gummy135413653gumm_y
gunman9299453gunman
guttae73210583guttae
hammal134512063hammal
hammam12419333hammam
hemal104419803he_mal
heme95034413he_m_e
hemmed144211463hemmed
hemmer134112643hemmer
hempie132410563hempie
herma105318883herma_
hermai118912863hermai
hetman112510603hetman
immane1038883_immane
jemmied19294483jemmied
jemmies18318333jemmies
jemmy19498553jemm_y
jimmie17376473jimmie
lamiae84817453lamiae
legman949653legman
leman75622603le_man
lemmata1144673lemmata
mae57659113___mae
mamma86317913mamma_
mammal95112753mammal
mammas94616403mammas
mammate104411273mammate
mammee94417853mammee
mammie94313783mammie
mediae94217413mediae
meme85330553me_m_e
mensae84114053mensae
merman10513863merman
momma85111053momma_
mommas94110653mommas
nema65522523ne_ma_
nemas75321573ne_mas
neume74414403neum_e
penman10312323penman
pennae84314033pennae
pommee122813283pommee
pommie123710503pommie
rediae74221993rediae
reggae858953reggae
regma84612333regma_
reimage1037913reimage
remade94316983remade
remake124016113remake
reman75730153re_man
remap95418103re_map
remate84428683remate
remise84221953remise
remote84222603remote
remove116115573remove
rename82718813rename
rummage1234583rummage
seaman84015903seaman
seme65836653se_m_e
sememe10129983sememe
semimat11412913semimat
semple103212753semple
sempre102710093sempre
sesame8311013sesame
setae56026223se_tae
stemma10328133stemma_
stemmas11256973stemmas
summa94713313summa_
summas104313163summas
summate113611663summate
tammie104212693tammie
teammate1245613teammate
telae54323293te_lae
temple102811333temple
teniae64517353teniae
terrae62915213terrae
testae64216253testae
thermae125310503thermae
venae85920983ve_nae
yeoman1138823yeoman

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.376475242.0
2DLD Change Limit1127162445.50020493.8
3Display Results2442440.0763210.5
 (SQL Overall)1786912445.95230022.0
 
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.