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

241 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
germina103850(None) 
germinal1147261germinal
berming123614832berming
ermine8416922_ermine
geminal10109912ge_minal
gemming13289152gemming
german9611982german_
germane1049662germane
germans1079472germans
germen9612312germen_
germens1078632germens
germier10309542germier
germinant1246182germinant
germinate1248632germinate
gorming112810832gorming
permian112612282permian
perming123416092perming
semina8915572se_mina
tegmina1035242tegmina
terminal1039732terminal
terming104016002terming
termini93410812termini
vermian12329712vermian
vermin113414522vermin_
agnomina1144263agnomina
alumina9510053alumina
arming94719803_arming
beaming123618803beaming
beriming13310463beriming
berlin83116373berlin_
berline93716853berline
berlins93216013berlins
carina84325333car_ina
carmine112918483carmine
ceria75125363cer_i_a
cering94522533cer_ing
cervine122610803cervine
corbina111911453corbina
cortina91915973cortina
corvina12229503corvina
cremini11229063cremini
deeming113913123deeming
degerming1435753degerming
derma84918513derm__a
dermic114511913dermi_c
dermis94717163dermi_s
dormin9312313dormin_
dormins10311273dormins
encina8310443_encina
erica7316543_er_ica
ermined10410603_ermined
ermines9416673_ermines
erring73816483_erring
farina94618233far_ina
farming133515083farming
feria85922713fer_i_a
ferine96422583fer_ine
fermata12278143fermata
ferment12315573ferment
fermi103914163fermi__
fermion1236763fermion
fermions1336203fermions
fermis114313503fermi_s
fermium1446353fermium
firming132811223firming
foramina1346163foramina
formica1436443formica
forming133615733forming
gamin84423003g_amin_
gamine94620153g_amine
gaming104622043g_aming
gamins94420053g_amins
gamming133112623gamming
garbing113613273garbing
garment10315233garment
garring93116713garring
gauming11319713gauming
gearing92818843gearing
gecking154111363gecking
geeing84313773ge_eing
gelding103911793gelding
gelling93219763gelling
geminate11411813ge_minate
gemma106311773ge_m_ma
gemmier12337383gemmier
gemmily1534603gemmily
gentian8310103gentian
genuine838373genuine
geranial949283geranial
gerbera1034773gerbera
gerbil938343gerbi_l
gerbils1037303gerbils
gerent73223103ger_ent
germ75428963germ___
germanic1367503germanic
germiest11249923germiest
germinally1655253germinally
germinated1446563germinated
germinates1347763germinates
germiness1257693germiness
germlike1535093germlike
germs85118873germ__s
germy115113663germ__y
gerund836163ger_und
getting93316563getting
gherkin1544043gherkin_
gherkins1643993gherkins
girding103611883girding
girning93210693girning
girting93113333girting
gleaming12277933gleaming
gliming113310133gliming
gordita945093gordita
gorging102611363gorging
goring84119573gor_ing
gormand1157453gormand
grain65126253g_rain_
grains74223093g_rains
grainy103914213g_rainy
grana65722093g_r_ana
greeing93613783greeing
gremial1039153gremial
gremlin1035563gremlin_
gremlins1136053gremlins
greying124110893greying
griming113612493griming
grin55733723g_r_in_
grind75917563g_r_ind
gringa838553g_r_inga
grins65427223g_r_ins
groin65521083g_roin_
groins73917203g_roins
gumming133810193gumming
gurging102910113gurging
gyring113910363gyr_ing
harmin113117393harmin_
harmine122816193harmine
harming133717933harming
harmins123716723harmins
helming133712003helming
hemin103620933he_min_
hemins113417573he_mins
hemming15269973hemming
herding122915123herding
herein93717793herein_
herma105318883herm__a
hermit11519443hermi_t
hermits12312143hermits
hernia9312293herni_a
heroin94420593heroin_
heroine103517493heroine
heroins103518013heroins
herring113615883herring
jarina134014063jar_ina
jerkin17258113jerkin_
jerking19308923jerking
jerkins18358253jerkins
kerbing14308483kerbing
kerfing15307533kerfing
kermis124012393kermi_s
kerning124010893kerning
kerria10339923kerri_a
lamina84920443_lamina
lemming12269393lemming
limina83514503_limina
lumina84613543_lumina
marina84623413mar_ina
medina94114093me_dina
merging112711763merging
merino8315093mer_ino
merlin83916683merlin_
merlins93015813merlins
merman10513863merman_
mermen10813813mermen_
mina65136933___mina
nervine102510633nervine
nerving112910833nerving
nomina83113683_nomina
numina83510843_numina
overmine13313663overmine
pembina1345223pembina
pereia85217983perei_a
perinea9313043per_inea
perking143716463perking
permit10321683permi_t
permits11314003permits
persona92812453persona
reaming103924013reaming
rearming111413613rearming
regina75317143re_gina
remind94819793re_mind
remint85329983re_mint
reremind1147513reremind
retina65023383re_tina
retsina74710603retsina
rumina83412483_rumina
sarcina9310733sarcina
seaming103222113seaming
seeming103216263seeming
seminal91213413se_minal
seminar979763se_minar
serein63318463serein_
sereins73716123sereins
serging93416673serging
serin55434443ser_in_
serine65432673ser_ine
sering74731813ser_ing
seringa83310743ser_inga
serins64029673ser_ins
sermon8413553sermon_
sermons9311783sermons
serving113014983serving
sestina72711973sestina
spermine12311433spermine
stamina9310793stamina
teaming103917593teaming
teeming103513093teeming
tegminal1144453tegminal
tegumina1143283tegumina
terbia8311163terbi_a
terminals1147463terminals
terminate11411203terminate
terminus1037393terminus
termite9313893termite
terrine72517573terrine
tertian7511193tertian
uremia82910893uremi_a
varmint12311683varmint
velamina1345663velamina
verbena1235373verbena
verdin103113023verdin_
verdins112812333verdins
verging123812303verging
vermis114214963vermi_s
versine102515173versine
versing112314193versing
vimina11339943_vimina
warming133515083warming
worming132811243worming
yerking15368813yerking
zeroing1738343zeroing

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 Limit1340272416.65620136.3
3Display Results2412410.0932591.4
 (SQL Overall)1786912417.15224984.8
 
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.