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

191 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
marinates11251638(None) 
marginates13168741marginates
marinades12268971marinades
marinate103017781marinate_
marinated122513171marinated
carinate103320252carinate_
carinated123414272carinated
laminates112712902laminates
machinates1747322machinates
magnates11511612ma_gnates
marginate12179602marginate_
marginated14187342marginated
marinade11259382marinade_
marinaded13276532marinaded
marinaras1145562marinaras
marinas93519392marina__s
marines93928012marin__es
muriates10312082muri_ates
paginates123111362paginates
patinates113814692patinates
urinates8314132_urinates
variates111214982vari_ates
agitates9310883_agitates
agnates82813193_a_gnates
airdates939723_airdates
alginates10310123alginates
alienates9310683_alienates
amirates101114793_amirates
animates101316423_animates
annates72415423_a_nnates
arenites8917103_arenites
arginases1046383_arginases
ariettes8411353_ariettes
arsenates979373_arsenates
aviates10313063_avi_ates
badinages13124873badinages
barites94322333bari__tes
baronages1247153baronages
cabinmates1643893cabinmates
califates14310113califates
carates95630613car__ates
carbonates1449133carbonates
carinae94318593carina_e_
carinas93622413carina__s
caritases1139763caritases
carnages11312213car_nages
caseinates1247443caseinates
catenates11311813catenates
cavitates14168963cavitates
coronates1110816923coronates
craniates11310653craniates
crinites10612763_crinites
deaminates1349383deaminates
derivates13310093derivates
dominates12311743dominates
drainages1145503drainages
emaciates1347883emaci_ates
emanates10311333ema__nates
emarginate1385453emarginate_
evaginates1475993evaginates
fabricates1746463fabricates
farinas103215243farina__s
fascinates1547153fascinates
frigates12310933_frigates
geminates12310043geminates
germinates1347763germinates
herniates1247333herniates
imbricates1645293imbricates
iodinates1048203iodinates
irrigates1057253irrigates
irritates977223irritates
jarinas143712193jarina__s
kainites1238793ka_inites
kalifates1646133kalifates
karates115617473kar__ates
labiates101011513labi_ates
laminate103014633laminate_
laminated122610283laminated
lancinates1247153lancinates
lapidates1247143lapidates
lariated91212063lari_ated
lariats7615053lari_at_s
loricates11310123loricates
macerates132113573macerates
machinate1647953machinate_
machinated1845663machinated
maculates132013723maculates
maenades1137473ma_enades
magnate10512703ma_gnate_
makebates1744973makebates
malates93522613ma__lates
maleates103316343ma_leates
malines93625603malin__es
manages103418963ma__nages
manatee9317663ma__natee
manatees10310423ma__natees
manats84623463ma__nat_s
mandarinates1552653mandarinates
mandates11314093ma_ndates
manganates1345953manganates
mannites10312613ma_nnites
mantes84430783ma__n_tes
maranatha1452953maranatha
maranathas1552253maranathas
marantas10310023maran_tas
marcatos1249163mar_catos
marginals1246013margina_ls
margraves1544833margraves
marina84623413marina___
marinara1046493marina_ra
marinating13410273marinating
marination12312813marination
marinations13411273marinations
marine84230403marin__e_
mariner93315993marin__er
mariners103113863marin_ers
marionettes1353003marionettes
marishes13512553mari_shes
marlines103818713marlin__es
marlites103415263mar_lites
marmites122212793mar_mites
marquisates2252223marquisates
marriages1247383marriages
martinets1138883martinet_s
martingales1452653martingales
maryjanes2142993maryjanes
masonites1149173masonites
masticates1449843masticates
matinees102110423matin_ees
maturates11311763maturates
maximites2045313maximites
mediates112814063medi_ates
medicates14312113medicates
meditates1239813meditates
melinites11310413melinites
meringues1244383meringues
metricates1449123metricates
militates11310883militates
minutes93513443m__inutes
mitigates1248253mitigates
motivates1447073motivates
muriate9313363muri_ate_
muriated1139793muri_ated
muricate12311113muricate_
muricated1448243muricated
murines93718223murin__es
mutilates11310953mutilates
narrates8312763nar_rates
navigates1345873navigates
nominates11311053nominates
ordinates1049003ordinates
paginate114012443paginate_
paginated13309463paginated
parietes10714543pari_etes
patinate103016313patinate_
patinated123911413patinated
patriates11311363patri_ates
primates121515933_primates
privates131812373_privates
pronates10418373_pronates
rabbinates1444513rabbinates
radiates92415293radi_ates
radicates12412073radicates
raffinates1644363raffinates
resinates9314763resinates
ruinates8311883_ruinates
ruminates11410193ruminates
salivates1239293salivates
sanitates9611733sanitates
satiates8314633sati_ates
seriates82620673seri_ates
striates83417083stri_ates
supinates1139553supinates
suricates11311743suricates
tannates81911953ta_nnates
tartrates979563tartrates
terminates12410003terminates
turbinates1245773turbinates
urinate7315363_urinate_
urinated9311613_urinated
vaccinates1746563vaccinates
vaginate123911083vaginate_
vaginated14328153vaginated
validates1338243validates
variances14117363variances
variants1139203variant_s
variate101316433vari_ate_
variated121211393vari_ated
variegates1444043variegates
variolates1347463variolates
veritates12310973veritates

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.423422437.4
2DLD Change Limit1486411917.20320636.0
3Display Results1911910.0932053.8
 (SQL Overall)1786911917.71923149.5
 
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.