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

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

92 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
glutamates135269(None) 
glutamate1242541glutamate_
glutamines1343502glutamines
automates11412053_automates
elutriates1045003elutriates
flatmates1446193flat_mates
gluconates1344393gluconates
glutaminases1551823glutaminases
glutamine1243573glutamine_
squamates2045593squ_amates
sultanates1045233sultanates
ultimates1148433ul_timates
agglutinates1472554agglutinates
aguacates1244584agu_acates
aliterates101510754aliterates
aluminates1248364aluminates
automate10411944_automate_
automated1248814_automated
automats10410444_automat_s
bunkmates1743674_bunkmates
butylates1444714_butylates
butyrates1446084_butyrates
carbamates1645624carbamates
catamites1349364_catamites
classmates1444504classmates
clathrates1545274clathrates
climates12311974cl__imates
cultivates1546514cultivates
cyclamates1943624cyclamates
deuterates1149084deuterates
eluates72014684elu___ates
elucidates1364874elucidates
elutriate945304elutriate_
elutriated1144554elutriated
eluviates1246104elu_viates
estimates11911364_estimates
flatmate1346394flat_mate_
fluctuates1543074fluctuates
fluxgates2042764flu_xgates
fumarates1445394_fumarates
gametes10312254g___ametes
gemmates13307674g__emmates
gestates93213734gest__ates
glaciates1267344gl_aciates
gluconate1244794gluconate_
glumes94516814glu__m__es
glutaminase1451874glutaminase
glutes74517674glu____tes
glutted937244glut___ted
gluttonies1143324gluttonies
gouramies1294764gouram_ies
gradates10510784g__radates
gratulates1157134gratulates
guanases936234g_u_anases
gummites1346174g_u_mmites
guttate8328904g_ut_tate_
guttated10266874g_ut_tated
hamates122917684___hamates
housemates1546134housemates
humates122813194_hu__mates
imamates1237664__imamates
intimates111013314_intimates
literates91415654_literates
litigates1048004_litigates
lustrates939464_lustrates
luxates1436974_lu__xates
mutates92215794_mut__ates
mutilates11310954_mutilates
nizamates2043274_nizamates
nutates73214974_nut__ates
ostomates1149344_ostomates
outdates93114744_out_dates
outrates82421374_out_rates
outskates13177154_outskates
outstates91710754_outstates
placates12311754pl__acates
playmates1646604pl_aymates
plumages1335654plu__mages
plumate1149804plu__mate_
runagates1044334_runagates
seatmates1157824seat_mates
soulmates1147074sou_lmates
squamate1945784squ_amate_
stomates10313344__stomates
sultanate946054sultanate_
summates122610494_su_mmates
tamales93216154___tamales
tantalates10106704tantalates
titanates976094_titanates
ultimate1049204ul_timate_
ultimated1247314ul_timated
ululates848434ulu__lates

Search took 10 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 Filter1786911614500.453394461.4
2DLD Change Limit161450929.39017193.8
3Display Results92920.0462000.0
 (SQL Overall)178691929.88918069.7
 
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.