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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

137 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
glace8742016(None) 
glaces94218031glaces
glade75121961glade
glance94312311glance
glare65222961glare
glaze155418161glaze
grace85124541grace
lace66848471_lace
place94824611place
ace59656832__ace
aglare7312432aglare
alack114820062alack
alae45643752ala_e
alane56135612alane
alate55340332alate
anlace82513922anlace
apace94718382apace
black134719072black
blade85923332blade
blae66134642bla_e
blame95625492blame
blare75826232blare
blase75524232blase
blate75933782blate
blaze165520832blaze
brace95629272brace
clach124617822clach
clack134720172clack
clade85821012clade
clave105420152clave
dace76934922_dace
elate55335882elate
enlace82213232enlace
face96140122_face
flack144519412flack
flake125119972flake
flame105124442flame
flare84823632flare
gae46457702g_a_e
gage65936102g_age
gale56347322g_ale
game76644322g_ame
gane55145302g_ane
gape75134512g_ape
gate55746572g_ate
gave84634052g_ave
gaze145032412g_aze
gelate73421262gelate
glaceed1136202glaceed
glacier103911302glacier
glacis94012132glacis
glad65624012gla_d
glades84820342glades
glads75620612glads
glady105413942glady
glair65313552glair
glaire74411302glaire
glaive10357932glaive
glam76529342gla_m
glams85822932glams
glanced11439232glanced
glancer103710072glancer
glances104113142glances
gland75217712gland
glans65125832glans
glared84715202glared
glares75518872glares
glary96018542glary
glass65518132glass
glazed174711772glazed
glazer164212262glazer
glazes165315642glazes
glazy187410982glazy
glebe85016442glebe
glede75517832glede
glee55239062gl_ee
glide74521592glide
glime85620192glime
globe84917012globe
glove94516292glove
gloze154815982gloze
glue55628492gl_ue
glume85120462glume
glute66020902glute
graced105217902graced
graces94523492graces
grade75126092grade
grape84824662grape
grate64932882grate
grave94624872grave
graze155820052graze
guaco85012162guaco
inlace82513042inlace
lac510155822_lac_
laced87132642_laced
lacer75833752_lacer
laces76141762_laces
lacey105820912_lacey
lack105837682_lack
lacs66942482_lacs
lacy95829632_lacy
lade56345982_lade
lake85741602_lake
lame66849292_lame
lance75126722_lance
lane45153332_lane
lase46148512_lase
late47560482_late
lave75642142_lave
laze136235052_laze
lice66045062_lice
luce65132572_luce
mace87345792_mace
pace86345772_pace
palace104516922palace
peace95026082peace
placed114318002placed
placer105117742placer
places104323702places
placet103923672placet
plack135017842plack
plage84520402plage
plaice10311552plaice
plane74929142plane
plate74635112plate
race66746262_race
relace83122152relace
slack115021762slack
slake93724052slake
slate55438282slate
slave84224032slave
slice74925822slice
solace83415822solace
space95325672space
tace65342512_tace
trace75829612trace
unlace82215172unlace

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538001371.53335094.6
3Display Results1371370.0462978.3
 (SQL Overall)1786911371.88994595.6
 
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.