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

145 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
glacial103814(None) 
englacial1252782englacial
facial113615632_facial
gavial10310082g_avial
gharial1137342gharial
glacially1544582glacially
glaciate1168072glaciate
glacier103911292glacier
glacis94012132glaci_s
glial66715432gl__ial
labial84714342_labial
laical8312322_laical
racial83419242_racial
spacial1138762spacial
abaxial1646183abaxial
acacia10311353acacia_
acacias11510403acacias
adagial946373adagial
adaxial1545323adaxial
aecial84817313_aecial
alodial899953alodial
asocial998653asocial
axial124515193__axial
biaxial1645363biaxial
bifacial15105273bifacial
bilabial1265683bilabial
biracial12107973biracial
brachial15219303brachial
clachan1437183clachan
clausal936273clausal
cloacal1135163cloac_al
coaxial16157003coaxial
cranial92114683cranial
crucial1157893crucial
eluvial1045853eluvial
facia103218463_facia_
faciae112913413_faciae
facials123310743_facials
facias113415803_facias
fascial1258303fascial
faucial1257323faucial
fecial114714623_fecial
filarial1147863filarial
flail85316183fla_i_l
fluvial1345363fluvial
fractal1237623fractal
galabia1038323galabia_
galabias1137733galabias
galangal1043893galangal
gavials1136603g_avials
gayal9312713g_a_yal
genial74917613g_enial
geranial949283geranial
gharials1245123gharials
glace87420153glac__e
glaceed1136193glaceed
glaceing1236533glaceing
glaces94218023glac_es
glaciated1365753glaciated
glaciates1267343glaciates
glaciers11277893glaciers
glacises1138503glacises
gladiate1057053gladiate
gladier93810993gladier
gladiola10113413gladiola
gladioli1083183gladioli
glair65313553gla_i_r
glaire74411293gla_ire
glairs75211333gla_irs
glairy10448273gla_iry
glaive10357933gla_ive
glancing1247063glancing
glarier84112203glarier
glaring93714883glaring
glazier17409353glazier
glazily2035383glazily
glazing183611003glazing
glia56423153gl__ia_
glias64618493gl__ias
global937663gl_obal
gloria71910543gloria_
glorias81610323glorias
glossal8447053glossal
glottal835103glottal
glucan936183gluc_an
gluteal854243gluteal
glycan1234903glyc_an
glycin1235963glyci_n
glycine1335713glycine
glycins1335563glycins
glycol1254933glyc_ol
glycyl1542793glyc_yl
gnathal1144353gnathal
gonadial1066823gonadial
graal64316503gra__al
gracile102512603gracile
gracing113216443gracing
gradual936943gradual
grail64622873gra_i_l
gremial1039153gremial
guaiac946153gua_iac
ilial55317843il__ial
jacal14313703_jac_al
jackal1937613_jackal
labia75219013_labia_
labials9299873_labials
lacier84020093_lacier
lacily11612763_lacily
lacing94626233_lacing
lacrimal1244443_lacrimal
lactam10310943_lactam
lacteal966813_lacteal
lacunal9136553_lacunal
lamia75324323_lamia_
lamiae84817453_lamiae
lamias85020613_lamias
laminal94113633_laminal
lanital7310913_lanital
lariat6629043_lariat
larval948503_larval
local74820273_loc_al
lochial1257083_lochial
malarial10410613malarial
narial6317953_narial
nasial6413283_nasial
ovarial1037613ovarial
palatial10410623palatial
pallial92911253pallial
pelagial1146543pelagial
placid114012543placi_d
placidly1644163placidly
placing123815283placing
plagal948573pla_gal
plical10411683plic_al
pluvial1245433pluvial
rachial122012173_rachial
radial74020393_radial
sacral83414413_sacral
social8813333_social
spatial9310323spatial
special11310303special
subglacial1552443subglacial
uncial83715223_uncial
uracil8311543uraci_l
zoarial1646923zoarial

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271456.61020276.4
3Display Results1451450.0463152.2
 (SQL Overall)1786911457.09225196.1
 
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.