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

134 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
nominate1031247(None) 
dominate11312851dominate
nominated1239281nominated
nominates11311051nominates
abominate1347022abominate
agminate1139242agminate
bombinate15155872bombinate
brominate1348852brominate
denominate13167682denominate
dominated1339882dominated
dominates12311742dominates
geminate11411812geminate
innominate1246122innominate
iodinate949342iodinate
laminate103014632laminate
nomina83113682nomina__
nominal92712372nomina_l
nominals10278612nominals
nominative1597682nominative
nominator1157822nominator
nominee9311582nomin_ee
renominate12178422renominate
ruminate10511472ruminate
abominated1545203abominated
abominates1446513abominates
acuminate1347573acuminate
alginate9310693alginate
aluminate1149373aluminate
amirate91115953_amirate
binate8419773__binate
bombinated17154123bombinated
bombinates16105013bombinates
brominated1546403brominated
brominates1448013brominates
carinate103320243carinate
cogitate1148553cogitate
cognate10312203co_gnate
coinage10310553co_inage
coinmate1239063co_inmate
comanage1346343comanage
comate104124843com__ate
comingle1336053comingle
comminute1596153comminute
connate9315753co_nnate
coronate103018213coronate
criminate1348983criminate
culminate1347813culminate
deaminate12410173deaminate
denominated15166253denominated
denominates14167203denominates
dominance1446213dominance
dominant1149523dominant
dominants1245953dominants
dominative1677393dominative
dominator1258233dominator
domine92918253domin__e
dominie103111643domin_ie
donate73619503do__nate
echinate1359403echinate
eliminate1147733eliminate
emanate9312473_emanate
emirate91015833_emirate
foliate10513533foli_ate
fomite113314073fomi__te
fulminate1446553fulminate
fumigate1446153fumigate
geminated1338553geminated
geminates12310043geminates
germinate1248633germinate
hominine1348913hominine
hominize2248593hominize
imitate9310873_imitate
inordinate1145943inordinate
inseminate1246683inseminate
iodinated1146943iodinated
iodinates1048203iodinates
laminae93512973lamina_e
laminated122610283laminated
laminates112712903laminates
loricate10310663loricate
marinate103017783marinate
minae75627723__mina_e
minute83414293__minute
misate81222693__misate
motivate1347693motivate
navigate1246073navigate
neonate7311333n_eonate
nidate7313783n__idate
nominally1446803nominally
nominating1349503nominating
nomination12712103nomination
nominatives1694773nominatives
nominators1277553nominators
nominees1037363nominees
nonage7313683no__nage
nonfinite1246163nonfinite
nonimage1144883nonimage
norite63221133nori__te
notate63217863no__tate
novenae1046323novena_e
noviciate1444423noviciate
novitiate1244223novitiate
numerate101610393numerate
numina83510843numina__
odonate848403_odonate
opiate8513463_opi_ate
ordinate9310253ordinate
ornate6315143_o_rnate
oxidate1537023_oxidate
ozonate1646863_ozonate
paginate114012443paginate
patinate103016313patinate
pointe84619313po_in_te
pollinate1147713pollinate
prenominate15156633prenominate
quinate16511573_quinate
renominated14146973renominated
renominates13137803renominates
resinate8316773resinate
ruinate7312833_ruinate
ruminated1258663ruminated
ruminates11410193ruminates
somite84519373somi__te
sonicate10310933sonicate
spinate93114813_spinate
staminate1187983staminate
supinate10310313supinate
terminate11411203terminate
uncinate10312393uncinate
unornate848013uno_rnate
urinate7315363_urinate
vaginate123911083vaginate
vomicae1445303vomica_e
zonate154114923zo__nate

Search took 7 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.420425454.8
2DLD Change Limit1461621346.44022696.0
3Display Results1341340.0602233.3
 (SQL Overall)1786911346.92025822.4
 
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.