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

158 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
geminate1141181(None) 
geminated1338551geminated
geminates12310041geminates
germinate1248631germinate
agminate1139242agminate
deaminate12410172deaminate
dominate11312852dominate
emanate9312472_emanate
emirate91015832_emirate
geminal10109912gemina_l
gemmate12418382gem_mate
germinated1446562germinated
germinates1347762germinates
laminate103014632laminate
nominate10312472nominate
resinate8316772resinate
ruminate10511472ruminate
terminate11411202terminate
abominate1347023abominate
acuminate1347573acuminate
agemate101210583agem__ate
alginate9310693alginate
aluminate1149373aluminate
amirate91115953_amirate
bemingle1346103bemingle
binate8419773__binate
bombinate15155873bombinate
brominate1348853brominate
carinate103320253carinate
celibate1259313celibate
criminate1348983criminate
culminate1347813culminate
deaminase1245383deaminase
deaminated1448013deaminated
deaminates1349383deaminates
decimate13411123decimate
dedicate12312803dedicate
definite1239323definite
delaminate1347373delaminate
delicate11315493delicate
delineate1047793delineate
denominate13167683denominate
depilate11311703depilate
derivate12311203derivate
designate1147113designate
detonate9311193detonate
deviate11312713devi_ate
dominated1339883dominated
dominates12311743dominates
echinate1359403echinate
effeminate1852973effeminate
eliminate1147733eliminate
emanated1139163_emanated
emanates10311333_emanates
emendate1146783_emendate
emigrate1149603_emigrate
emirates101214853_emirates
emulate9314123_emulate
enate54428153_e__nate
epilate9314283_epilate
feminacy1844453feminacy
feminazi2243133feminazi
feminie12179933femin_ie
feminine13199783feminine
feminise132010293feminise
feminity1647543feminity
feminize22199373feminize
festinate1249473festinate
fulminate1446553fulminate
fumigate1446153fumigate
gamine94620153gamin__e
gelate73421263ge__late
gelignite1143993gelignite
geminally1576403geminally
geminating1447763geminating
gemination131410663gemination
gemmae11507793gem_ma_e
gemmated14336293gem_mated
gemmates13307673gem_mates
gemote94613023gem__ote
generate9312903generate
germina1038503germina__
germinal1147263germina_l
germinant1246183germinant
germinative1755043germinative
gestate83614073ge_state
herniate1148113herniate
hesitate1169973hesitate
imitate9310873_imitate
inseminate1246683inseminate
iodinate949343iodinate
laminae93512973lamina_e
laminated122610283laminated
laminates112712903laminates
lemonade1144283lemonade
levigate1246623levigate
levirate1147623levirate
levitate1137933levitate
marinate103017783marinate
mediate103415213medi_ate
medicate13513243medicate
meditate11310623meditate
melinite10411753melinite
minae75627723__mina_e
minute83414293__minute
misate81222693__misate
neonate7311333ne_onate
nominated1239283nominated
nominates11311053nominates
ordinate9310253ordinate
paginate114012443paginate
patinate103016313patinate
pectinate1349553pectinate
pennate93314033pe_nnate
pepsinate1346633pepsinate
quinate16511573_quinate
reclinate11410023reclinate
reginae84713453regina_e
remate84428683rem__ate
remigrate1249223remigrate
remint85329983remin_t_
reminted113615083remin_ted
remints95117293remin_ts
renominate12178423renominate
resinated10413283resinated
resinates9314763resinates
resonate8513513resonate
retinae75517333retina_e
retinite8314853retinite
ruinate7312833_ruinate
ruminated1258663ruminated
ruminates11410193ruminates
selenate81712533selenate
semimat11412913semimat_
semimatt1258313semimatt
semimatte1354733semimatte
semimute1245513semimute
semina8915573semina__
seminal91213413semina_l
seminar979763semina_r
seminars1079053seminars
seminary1398103seminary
seminude1145673seminude
senate63725173se__nate
serenate81914883serenate
seriate73722473seri_ate
spinate93114813_spinate
staminate1187983staminate
supinate10310313supinate
template1238433template
terminated1348163terminated
terminates12410003terminates
ternate7415483te_rnate
uncinate10312393uncinate
urinate7315363_urinate
vaginate123911083vaginate
venenate1147933venenate
vesicate131210053vesicate

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621586.86021306.4
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.35924282.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.