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

74 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
glaciates126735(None) 
glaciate1168081glaciate_
glaciated1365761glaciated
emaciates1347882emaciates
glacises1138512glaci_ses
gladiate1057052gladiate_
labiates101011512_labiates
lactates10311232_lactates
placates12311762plac_ates
aguacates1244583aguac_ates
aviates10313073__aviates
bloviates1484553bloviates
brachiates1746353brachiates
calcites12313003calci_tes
craniates11310653craniates
dacites101114593_daci_tes
deglaciated1652403deglaciated
elucidates1364883elucidates
eluviates1246103eluviates
emaciate1248753emaciate_
emaciated1446933emaciated
eradiates102010783eradiates
evacuates14256803evacuates
flatmates1446193flatmates
gallates92815533g_allates
glabrate1146043glabrate_
glaces94218033glac___es
glacial1038143glacia__l
glacially1544583glacially
glaciating1445603glaciating
glaciation1346583glaciation
glaciations1445963glaciations
glacier103911303glaci__er
glaciered1343883glaciered
glaciers11277903glaci_ers
glacis94012133glaci___s
gladiator1143723gladiator
gladiators1243733gladiators
glaires84010143gla_i_res
glaives11347833gla_i_ves
gluconates1344403gluconates
glycines1445083glyci_nes
graciles112511613graci_les
gradates10510783gra_dates
graduates1147683graduates
granites92116363grani_tes
gravitates1444843gravitates
labiate91313573_labiate_
labiated11109303_labiated
lacerates112413783_lacerates
lactases1038523_lactases
lactate9312703_lactate_
lactated1138873_lactated
laminates112712903_laminates
lancinates1247153_lancinates
lapidates1247143_lapidates
lariated91212063_lariated
lariats7615053_lariat_s
leachates1446663leachates
locates93218813_loc_ates
lucites9311863_luci_tes
palliates11311043palliates
placate11312433plac_ate_
placated1338453plac_ated
placater1238013plac_ater
placaters1336473plac_aters
playdates1554903playdates
playmates1646603playmates
radiates92415293_radiates
satiates8314633_satiates
speciates13229233speciates
tractates1159763tractates
vacates12312833_vac_ates
variates111214983_variates

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.420425454.8
2DLD Change Limit148641747.05021083.8
3Display Results74740.0302466.7
 (SQL Overall)178691747.50023825.5
 
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.