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

229 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
egalite831156(None) 
egalites9310501egalites
elite56230182e__lite
halite93624232_halite
hyalite13229472hyalite
legalise949492legalise
legality1237622legality
legalize1839102legalize
megalith1448242megalith
regality1249312regality
uralite71714102uralite
aerolite8315053aerolite
agamete1037403agamete
agate66525153aga__te
agatize1739833agatize
agility1148653agility
alate55340323__alate
albite8313313__albite
alike95523963__alike
aline57243153__aline
alit46155693__alit_
alive85722513__alive
analcite1049333analcite
anality10313633anality
analyte10158813analyte
apatite9312963apatite
aplite8316393_aplite
axite125218253__axite
baglike14338943baglike
barite84224813_barite
bengaline1245633bengaline
blite76225353__blite
calcite11413783_calcite
chalice14311043chalice
cyanite122710763cyanite
dacite91115883_dacite
dealate83617843dealate
decaliter1247983decaliter
dekaliter1445063dekaliter
dekalitre1442823dekalitre
duality1147963duality
dualize1759763dualize
eagle64219483eagl__e
eaglet73722583eaglet_
eaglets84111663eaglets
eagling91113603eagling
ebonite9310293ebonite
ecarte84313503eca_rte
edacity1336373edacity
eellike1138233eellike
egal55119433egal___
elapine9310673elapine
elate55335883e__late
elative10312453elative
elflike1435133elflike
elide64922643e__lide
elites66027123e__lites
elute54822573e__lute
emaciate1248753emaciate
emanate9312473emanate
emulate9314123emulate
enamine91214313enamine
enate54428153ena__te
endite73817593e_ndite
eolith93013903e_olith
epazote1843703epazote
epilate9314283epilate
equalise1748213equalise
equality2046993equality
equalize2648023equalize
eradiate91911753eradiate
eremite9312833eremite
ergate7315143erga__te
ergative1238973ergative
erudite838483erudite
escalate1039323escalate
etamine91313073etamine
eucrite939903eucrite
evaluate11287793evaluate
evasive1344663evasive
evite85317683e__vite
evolute1045683evolute
exabyte1943523exabyte
exalt123018533exal_t_
exalted1537393exal_ted
exalter1437563exal_ter
exalts13328313exal_ts
examine161510033examine
excite15310883e_xcite
eyelike1436973eyelike
fayalite1447053fayalite
flite85424963__flite
gahnite1135973_gahnite
gait56150193_ga_it_
gaited84416923_ga_ited
gaiter73819503_ga_iter
gaits65726013_ga_its
galatea839953_galatea
gale56347323_gal__e
galeae74717453_galeae
galeate83916783_galeate
galenite91210063_galenite
galere73716673_galere
galette84212693_galette
galilee8312213_galilee
galiot72322593_galiot
galiots82311323_galiots
gallate83417123_gallate
gallet73630853_gallet
galore73514853_galore
gamete9313593_gamete
gamine94620153_gamine
garote7717953_garote
gaslit7513503_gaslit_
gate55746573_ga__te
gelate73421253_gelate
gemlike14206813gemlike
gite55438613_g__ite
glaire74411293_glaire
glaive10357933_glaive
glide74521593_g_lide
glime85620193_g_lime
glitz154916373_g_litz
glute66020903_g_lute
goalie7413163goali_e
granite82017083granite
gunite7414403_gunite
halide103417993_halide
halites103221193_halites
haplite12310703haplite
hematite131612153hematite
hoplite12311073hoplite
hyaline132310723hyaline
hyalites14208833hyalites
ignite71410583ig_nite
illite63414923_illite
iolite63221983_iolite
kyanite14237313kyanite
legalese954753legalese
legalised1145843legalised
legalises1038563legalises
legalism1148583legalism
legalist9512393legalist
legalists1047943legalists
legalities1148913legalities
legalized2047523legalized
legalizer1946323legalizer
legalizes1938673legalizes
legate72917453lega__te
legatine91311403legatine
leglike12136843leg_like
lite47054543___lite
localite101411543localite
malate84624553_malate
malice104818483_malice
maline84529083_maline
marlite92917073marlite
mealie82519813meali_e
megabit12117963megabit_
megabits1355793megabits
megabyte1643193megabyte
megacity1645713megacity
megahit1378773megahit_
megahits1445683megahits
megaliths1544743megaliths
melanite10512033melanite
melilite10410573melilite
metalise10416053metalise
metalize19414783metalize
mullite9313013mullite
negate72915573nega__te
negative1239083negative
neglige934873neg_lige
oolite63319603_oolite
opaline9412483opaline
orality101111683orality
ovality1377593ovality
oxalate1457623oxalate
palate84226783_palate
pealike131211273pealike
pearlite1039443pearlite
peglike14136773peg_like
pegmatite1445723pegmatite
pelite84323003_pelite
penalise101013763penalise
penality13310713penality
penalize19912753penalize
penlite9313243penlite
perlite9317323perlite
petaline10314883petaline
polite83625073_polite
praline93019743praline
quality1938563quality
ratite65022423_ratite
realise73021813realise
reality10313573reality
realize162717083realize
regale74821453regal__e
regalia839223regali_a
regaling10315363regaling
regalities11410593regalities
regelate9312083regelate
regolith1247543regolith
regulate9313023regulate
reguline939503reguline
resalute857413resalute
retaliate9410643retaliate
ruralite848963ruralite
saline65132703_saline
saltie63422433_saltie
salute64418023_salute
samite83020603_samite
sepaline10311343sepaline
smaltite1046903smaltite
sodalite9109593sodalite
stylite10219613stylite
taglike12278913taglike
tagline82412453tagline
taxite13511303_taxite
tealike111111083tealike
tillite7313563tillite
unakite1138743unakite
unalike11311533unalike
uralites82112723uralites
uranite72515693uranite
valine94623093_valine
valise92917643_valise
venality1438683venality
zeolite1638903zeolite

Search took 7 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.406440125.6
2DLD Change Limit1340272296.23321502.8
3Display Results2292290.0932462.4
 (SQL Overall)1786912296.73226543.5
 
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.