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

205 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
laminate10301463(None) 
laminae93512971lamina_e
laminated122610281laminated
laminates112712901laminates
agminate1139242agminate
alginate9310692alginate
aluminate1149372aluminate
amirate91115952_amirate
carinate103320242carinate
deaminate12410172deaminate
delaminate1347372delaminate
dominate11312852dominate
eliminate1147732eliminate
geminate11411802geminate
labiate91313572labi_ate
laciniate1156842laciniate
lacunate10128962lacunate
lamiae84817452lami_a_e
lamina84920442lamina__
laminable1337122laminable
laminal94113632lamina_l
laminals10339302laminals
laminar93810282lamina_r
laminary13337252laminary
laminas93615872lamina_s
laminator1147552laminator
laminose1036912laminose
lanate6421262la__nate
lancinate1147802lancinate
lapidate1157902lapidate
marinate103017782marinate
nominate10312472nominate
paginate114012442paginate
patinate103016312patinate
ruminate10511472ruminate
staminate1187982staminate
vaginate123911082vaginate
abominate1347023abominate
acuminate1347573acuminate
adnate72913483_a_dnate
agitate8312063_agitate
agnate73314883_a_gnate
alginates10310123alginates
alienate8311553alienate
aluminates1248363aluminates
amidase1036733_amidase
amine75835383_amin__e
aminity12310513_aminity
amirates101114793_amirates
amniote936963_amniote
animate91617213_animate
aviate9315203_avi_ate
badinage1294923badinage
binate8419773__binate
bombinate15155873bombinate
brominate1348853brominate
cabinmate1544093cabinmate
califate13310483califate
camisade1374823camisade
capitate121712183capitate
carinae94318583carina_e
carinated123414263carinated
caseinate1148243caseinate
catenate10312833catenate
catkinate1545823catkinate
cavitate13159833cavitate
criminate1348983criminate
culminate1347813culminate
deaminase1245383deaminase
deaminated1448013deaminated
deaminates1349383deaminates
delaminated1545783delaminated
delaminates1456903delaminates
dominated1339883dominated
dominates12311743dominates
echinate1359403echinate
eliminated1345953eliminated
eliminates1246973eliminates
emanate9312473_emanate
emirate91015833_emirate
evaginate1376483evaginate
famine114318193famin__e
fascinate1447763fascinate
fulminate1446553fulminate
fumigate1446153fumigate
gamine94620153gamin__e
geminated1338543geminated
geminates12310033geminates
germinate1248623germinate
glaciate1168073glaci_ate
gladiate1057053gladi_ate
hamate113319833ham__ate
hamulate1359013hamulate
illuminate1245683illuminate
imitate9310873_imitate
iodinate949343iodinate
kainite1149543ka_inite
kalifate1556493kalifate
kamikaze2241243kamikaze
labiated11109303labi_ated
labiates101011513labi_ates
lacerate102214703lacerate
lactate9312693la_ctate
lacunae9116803lacuna_e
lambaste12145013lambaste
lamellate11116703lamellate
lament85024943lamen_t_
lamented1138193lamen_ted
lamenter1038863lamen_ter
laments94314853lamen_ts
lamia75324323lami_a__
lamias85020613lami_a_s
laminaria1145183laminaria
laminarin1146083laminarin
laminating1348723laminating
lamination12311223lamination
laminators1247053laminators
laming94528363lamin__g
laminin939973lamin_in
laminins1039133laminins
laminitis1146243laminitis
laminous1037953laminous
lamister1037653lami_ster
lanated8313203la__nated
lancinated1345573lancinated
lancinates1247153lancinates
lapidated1345673lapidated
lapidates1247143lapidates
lariat6629043lari_at_
lariated91212063lari_ated
lariats7615053lari_ats
larine63927043larin__e
latina65621143latina__
latinas74416463latina_s
latinity1138813latinity
latinize17610563latinize
laureate888023laureate
lawine93316463lawin__e
lemonade1144283lemonade
levigate1246623levigate
levirate1147623levirate
levitate1137933levitate
ligate72519253l__igate
limbate1139213lim_bate
limina83514503limina__
liminal93810673limina_l
limonite1048163limonite
linage7713403l__inage
lineate7815153l__ineate
litigate948303litigate
loricate10310663loricate
lumina84613543lumina__
luminaire1143933luminaire
luminal93711003lumina_l
luminance1345163luminance
luminary13336653luminary
lunate6316043l__unate
machinate1647953machinate
magnate10512703ma_gnate
mammate104411273mam_mate
marginate12179603marginate
marinade11259383marinade
marinated122513173marinated
marinates112516383marinates
minae75627723__mina_e
minute83414293__minute
misate81222693__misate
navigate1246073navigate
nominated1239283nominated
nominates11311053nominates
ordinate9310253ordinate
paginated13309463paginated
paginates123111363paginates
palatinate1245593palatinate
palmitate1346413palmitate
patinae95414403patina_e
patinated123911413patinated
patinates113814693patinates
planate9314573pla__nate
quinate16511573_quinate
rabbinate1345143rabbinate
radiate83416313radi_ate
radicate11412873radicate
raffinate1545023raffinate
ramate83921683ram__ate
resinate8316773resinate
ruinate7312833_ruinate
ruminated1258663ruminated
ruminates11410193ruminates
salivate11310013salivate
samite83020603sami__te
sanitate8612043sanitate
satiate7315403sati_ate
slainte738543sla_in_te
spinate93114813_spinate
supinate10310313supinate
tannate71813523ta_nnate
terminate11411203terminate
uncinate10312393uncinate
urinate7315363_urinate
vaccinate1646833vaccinate
vaginae11377683vagina_e
vaginated14328153vaginated
validate1239003validate
variate101316433vari_ate

Search took 9 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 Limit1461622058.22017781.3
3Display Results2052050.0762697.4
 (SQL Overall)1786912058.73220463.9
 
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.