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

185 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
glacises113850(None) 
glaces94218022glac__es
glaciates1267342glaciates
glacier103911292glaci_er
glaciers11277892glaciers
glacis94012132glaci__s
glaires84010132gla_ires
glaives11347832gla_ives
glasses84414272gla_sses
glassies94012272glassies
glucoses1145332glucoses
glycines1445082glycines
graciles112511612graciles
laicises1039572_laicises
lapises93513462_lapises
abacuses1235763abacuses
abatises10311013abatises
abscises1246233abscises
alanines8314803alanines
alcaides11117673alcaides
alkalises13167483alkalises
anaclises1147863anaclises
anglicises1344403anglicises
anises64826693__anises
arises65233803__arises
axises134413993__axises
braises93818873bra_ises
calcines12314753calcines
calcites12313003calcites
camises114218463_camises
cercises12410933cercises
chaises124317493cha_ises
chamises153513313chamises
cladisms1336093cladisms
cladists1136723cladists
claries93422203clari_es
classes94717943cla_sses
clauses93813323cla_uses
clevises1336903clevises
dacites101114593_dacites
daises74318983_da_ises
elapses957663ela_pses
elatives1139783elatives
elegises9128823elegises
excises1638933_excises
facies113921593_faci_es
flamines13311643flamines
flatuses1137173flatuses
flavines1437893flavines
fracases1336993fracases
fraises104215693fra_ises
gabies93820733g_abi_es
galactoses1344243galactoses
galaxies1637163galaxi_es
gallies84122713galli_es
galluses936963galluses
galvanises1444653galvanises
gamines103618463g_amines
gases65633993g_a__ses
gasses75724783g_a_sses
gausses8308693g_ausses
gearcases1254693gearcases
gelatines102910533gelatines
genoises939253genoises
ghazies2036913ghazi_es
glace87420153glac__e_
glaceed1136193glac_eed
glacial1038143glaci_al
glaciate1168073glaciate
glaciated1365753glaciated
glaciered1343863glaciered
glades84820343gla__des
gladier93810993gladi_er
gladiest101710333gladiest
gladness1036153gladness
glaiket1238363gla_iket
glaire74411293gla_ire_
glaired9387743gla_ired
glairs75211333gla_i_rs
glaive10357933gla_ive_
glaived12375973gla_ived
glamorises1385713glamorises
glances104113143gla_nces
glandes95413833gla_ndes
glares75518863gla__res
glarier84112203glari_er
glariest92012523glariest
glariness1038553glariness
glass65518133gla__s_s
glassed93710433gla_ssed
glassie8329493glassie_
glassier9289083glassier
glassiest10279243glassiest
glassines10278043glassines
glazes165315643gla__zes
glazier17409353glazi_er
glaziers18406563glaziers
glaziest18227913glaziest
glaziness1935753glaziness
glazings19325753glazings
gliadines1144773gliadines
glides84518863gl__ides
glimes94717523gl__imes
glimpses1343953glimpses
globalises1354593globalises
glories81915913glori_es
glosses84014123gl_osses
glossies93311253glossies
glottises1084953glottises
glucose1045113glucose_
glycine1335713glycine_
glycins1335563glyci_ns
goalies8316023goali_es
graces94523493grac__es
gracile102512603gracile_
gracilis11247033gracilis
graciosos1243253graciosos
gracious1138593gracious
grackles15309183grackles
gradines103615253gradines
graduses1046453graduses
graecizes2144573graecizes
granites92116363granites
grasses84117343gra_sses
gravies11314093gravi_es
grecizes2035683grecizes
guanases936233guanases
guanines989773guanines
guises74216313g__uises
incises93414893_incises
kyanises15206393kyanises
laces76141763_lac__es
laches116528343_lac_hes
lacier84020093_laci_er
laciest93819033_laciest
laciness102112553_laciness
lacings105013653_lacings
lactases1038513_lactases
lactoses1039813_lactoses
lacunes9159623_lacunes
ladies75124883_ladi_es
laicise939333_laicise_
laicised1145643_laicised
laicisms1247123_laicisms
laicizes1937403_laicizes
lapides103012043_lapides
lapses85217693_la_pses
lases54944763_la__ses
lasses64827593_la_sses
lassies74420103_lassies
latices9313763_latices
lavishes1457403_lavishes
lawines103313563_lawines
lazies154418783_lazi_es
lewises1039133_lewises
liaises7311053_liaises
lorises73918593_lorises
lucites9311863_lucites
malaises10312333malaises
mavises122812993_mavises
oxalises1538503oxalises
parises94827183_parises
pavises125315493_pavises
placates12311753placates
places104323703plac__es
plaices11411143pla_ices
planishes14138523planishes
platies93722543plati_es
polarises11514073polarises
practises1349623practises
praises94121103pra_ises
praxises1739063praxises
precises123218333precises
rachises131412413_rachises
racisms112310813_racisms
racists92613323_racists
raises64826543_ra_ises
realises82420183realises
rhachises1763973rhachises
solarises9512703solarises
solecises1189103solecises
tallises82713263tallises
tamises92715973_tamises
tapises92914013_tapises
valises103516263_valises

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621856.53322372.9
3Display Results1851850.0762434.2
 (SQL Overall)1786911857.02925422.0
 
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.