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

102 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
nominated123928(None) 
dominated1339881dominated
nominate10312471nominate_
nominates11311051nominates
abominated1545202abominated
bombinated17154122bombinated
brominated1546402brominated
denominated15166252denominated
dominate11312852dominate_
dominates12311742dominates
geminated1338542geminated
iodinated1146942iodinated
laminated122610282laminated
nominator1157822nominator
renominated14146972renominated
ruminated1258662ruminated
abominate1347023abominate_
abominates1446503abominates
acuminated1545873acuminated
agminate1139243agminate_
anointed938343ano_in_ted
bombinate15155873bombinate_
bombinates16105003bombinates
brominate1348853brominate_
brominates1448003brominates
carinated123414263carinated
cogitated1346323cogitated
comanaged1544523comanaged
combated1539823com_bated
comingled1543203comingled
comminuted17224573comminuted
coronated123313323coronated
criminated1546823criminated
culminated1546103culminated
deaminated1448013deaminated
denominate13167683denominate_
denominates14167203denominates
dominator1258233dominator
donated93513863do__nated
echinated1546483echinated
eliminated1345953eliminated
emanated1139163_emanated
foliated1249913foli_ated
fomented1437803fomen_ted
fulminated1645023fulminated
fumigated1644723fumigated
geminate11411793geminate_
geminates12310033geminates
germinated1446563germinated
hominized2446843hominized
imitated1138263_imitated
innominate1246123innominate_
inseminated1445043inseminated
iodinate949343iodinate_
iodinates1048203iodinates
jointed15378503jo_in_ted
laminate103014633laminate_
laminates112712903laminates
loricated1247893loricated
marinated122513173marinated
minted94220583__min_ted
minuted10329503__minuted
motivated1545963motivated
navigated1445483navigated
nidated939863n__idated
nomina83113683nomina___
nominal92712373nomina__l
nominally1446803nominally
nominals10278613nomina_ls
nominating1349493nominating
nomination12712103nomination
nominative1597683nominative
nominatives1694773nominatives
nominators1277553nominators
nominee9311583nomin__ee
nominees1037363nomin_ees
nonrated9310843no_nrated
notated82713663no__tated
numerated12177873numerated
omitted10347893_omi_tted
opiated1039483_opi_ated
oxidated1745033_oxidated
ozonated1864593_ozonated
paginated13309463paginated
patinated123911413patinated
pointed103813983po_in_ted
pollinated1345823pollinated
prenominated17185203prenominated
reminted113615083remin_ted
renominate12178423renominate_
renominates13137803renominates
resinated10413283resinated
ruinated939523_ruinated
ruminate10511473ruminate_
ruminates11410193ruminates
sonicated1248453sonicated
supinated1237873supinated
terminated1348163terminated
urinated9311613_urinated
vaginated14328153vaginated
vomited1337253vomi__ted
zonated173310533zo__nated

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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411027.58019609.6
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.79622920.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.