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

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
glaciate116807(None) 
glaciated1365751glaciated
glaciates1267341glaciates
gladiate1057051gladiate
emaciate1248752emaciate
glabrate1146032glabrate
glacial1038142glacia_l
labiate91313572_labiate
lactate9312692_lactate
placate11312432plac_ate
acuate8315633__acuate
aguacate1144973aguac_ate
aviate9315203__aviate
baccate131011263_baccate
bilabiate1344573bilabiate
bloviate1384913bloviate
brachiate1646873brachiate
calceate1239863calceate
calcite11413783calci_te
clavate1238713cla_vate
craniate10312563craniate
cruciate1287313cruciate
dacite91115883_daci_te
deglaciated1652403deglaciated
elucidate1265423elucidate
eluviate1146953eluviate
emaciated1446933emaciated
emaciates1347883emaciates
eradiate91911753eradiate
evacuate13217303evacuate
faciae112913413_facia_e
falcate12311613falc_ate
fasciate1347563fasciate
flatmate1346393flatmate
galeate83916783g_aleate
gallate83417123g_allate
glace87420153glac___e
glacially1544583glacially
glaciating1445593glaciating
glaciation1346583glaciation
glacier103911293glaci_er
glaciered1343863glaciered
glaciers11277893glaciers
glacis94012133glaci__s
glacises1138503glacises
gladiator1143723gladiator
glaiket1238363gla_iket
glaire74411293gla_i_re
glaive10357933gla_i_ve
globate1057823gl_obate
gluconate1244793gluconate
glycine1335713glyci_ne
gracile102512603graci_le
gradate9511233gra_date
graduate1058083graduate
granite82017083grani_te
gravitate1345543gravitate
labiated11109303_labiated
labiates101011513_labiates
lacerate102214703_lacerate
laciniate1156843_laciniate
lactase937953_lactase
lactated1138863_lactated
lactates10311223_lactates
lacunate10128963_lacunate
lamiae84817453_lamia_e
laminate103014633_laminate
lanate6421263_la_nate
lancinate1147803_lancinate
lapidate1157903_lapidate
lariat6629043_lariat_
lariated91212063_lariated
lariats7615053_lariats
leachate1347443leachate
locate83919843_loc_ate
lucite8313343_luci_te
palliate10311893palliate
placated1338453plac_ated
placater1238013plac_ater
placates12311753plac_ates
planate9314573pla_nate
playdate1465263playdate
playmate1566463playmate
plicate11314513plic_ate
radiate83416313_radiate
saccate111311763_saccate
satiate7315403_satiate
slainte738543sla_inte
speciate12209583speciate
tractate10411003tractate
vacate11314553_vac_ate
variate101316433_variate

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.406440125.6
2DLD Change Limit146162927.75018859.6
3Display Results92920.0303066.7
 (SQL Overall)178691928.18621828.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.