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 “marinating” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
marinating1341027(None) 
marginating1545891marginating
marinading1445611marinading
laminating1348732laminating
lariating10311792lari_ating
machinating1945622machinating
marination12312812marination
marinations13411282marinations
paginating1447532paginating
patinating1339882patinating
urinating10310652_urinating
variating13310952vari_ating
agitating1138863_agitating
alienating1147233_alienating
animating12312513_animating
arointing1049363_aroin_ting
aviating12311033_avi_ating
badinaging1543173badinaging
carbonating1645863carbonating
catenating1348683catenating
cavitating1646913cavitating
coronating13410173coronating
deaminating1547973deaminating
dominating1449403dominating
emaciating1546823emaci_ating
emanating1239003ema__nating
evaginating1644913evaginating
fabricating1945033fabricating
fainting123312163fa_in_ting
fascinating1745253fascinating
geminating1447763geminating
germinating1546173germinating
herniating1445983herniating
imbricating1844523imbricating
imprinting1546023imprin_ting
iodinating1246963iodinating
irrigating1245953irrigating
irritating1146293irritating
lancinating1445453lancinating
lapidating1445243lapidating
macerating1549543macerating
maculating1549553maculating
maintain1077723ma_intain_
maintains1167103ma_intains
managing1239093ma__naging
mandating1339773ma_ndating
margenting1446153margenting
margination1447433margination
marginations1546463marginations
margining1337603margin__ing
marinate103017783marinat__e
marinated122513173marinat_ed
marinates112516393marinat_es
marketing1636513mar_keting
marshaling1645083marshaling
marting103325023mar___ting
masticating1647833masticating
maturating13108573maturating
mediating13311203medi_ating
medicating1648953medicating
meditating1448123meditating
meriting11314693meri__ting
metricating1647363metricating
militating1348823militating
minting103020813m__in_ting
minuting1139723m__inuting
mitigating1447433mitigating
mordanting1444003mordanting
motivating1646803motivating
mutilating1349083mutilating
narrating10310353nar_rating
navigating1545003navigating
nominating1349503nominating
painting113614423pa_in_ting
parenting12611583paren_ting
patriating13510203patri_ating
printing113216083_prin_ting
pronating12313763_pronating
radiating111112133radi_ating
radicating1459073radicating
resinating11313733resinating
ruinating1039593_ruinating
ruminating1348143ruminating
sainting93215733sa_in_ting
salivating1447443salivating
sanitating1149653sanitating
satiating10311813sati_ating
seriating10916403seri_ating
sprinting12310033sprin_ting
striating10914193stri_ating
supinating1357833supinating
tainting93613583ta_in_ting
terminating1447353terminating
vaccinating1945193vaccinating
validating1545843validating
variegating1643213variegating
variolating1544943variolating
warranting1444743warranting

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 Filter1786911406030.406440125.6
2DLD Change Limit140603985.70324654.2
3Display Results98980.0462130.4
 (SQL Overall)178691986.15529031.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.