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

442 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
lucite831334(None) 
leucite937751leucite
lucites9311861lucites
alunite7311632alunite
augite7312612augite
cite65640342__cite
curite85222942curite
dacite91115882dacite
dunite7315012dunite
eucrite939902eucrite
excite15310882excite
gunite7414402gunite
incite83618722incite
lenite6719982lenite
leucine938072leucine
leucites1037332leucites
licit74327682licit_
lite47054542l__ite
locate83919842locate
luce65132572luc__e
lucid84314572luci_d
lucifer1234602lucifer
luckie123611412luckie
lucre76415522luc_re
lunate6316042lunate
lupine84013532lupine
lute46341012lu__te
luxate1338082luxate
quite144621462qu_ite
recite83625112recite
suite54829562su_ite
unite54828382_unite
acuate8315633acuate
acuity1139373acuity
acute74720363_acute
albite8313303albite
alumine9412693alumine
alunites8310703alunites
aplite8316393aplite
ascites9312603ascites
audile73315303audile
audit62527883audit_
audited939033audited
auditee8311573auditee
audits72814113audits
augites8312183augites
auntie64317703auntie
aurate64426473aurate
axite125218253_axite
azurite1638003azurite
barite84224813barite
bauxite1635573bauxite
bite66546993__bite
blite76225353_blite
boite74426323_boite
brucine1138273brucine
bucket144620733bucket
buckle144815193buckle
burkite1337003burkite
bute66739673bu__te
butte74924293bu_tte
calcite11413783calcite
cate66254593__cate
cecity1398153cecity
cerite84724873cerite
cete64934783__cete
cine66242943__cine
cire65836373__cire
cited84421953__cited
citer74827323__citer
cites74435583__cites
city95122623__city
cote66648733__cote
cruciate1287313cruciate
cubit94122883cubit_
cubiti10399073cubiti
cubits103714023cubits
cuprite1159683cuprite
curate85226243curate
curiae84518373curiae
curie74533033curi_e
curites93919863curites
cute66440453__cute
cutie76925923cuti_e
dacites101114593dacites
decide104116873decide
decile94619213decile
dite55547553__dite
docile94213123docile
ducat86225903ducat_
ducats95011763ducats
duce76933503duc__e
duci76422623duci__
duckie133511663duckie
duct75735463duc_t_
ducted104012123duc_ted
ductile1048473ductile
ducts85319893duc_ts
duit56241583du_it_
duits65021883du_its
dunites8313593dunites
dunnite857333dunnite
educate10310213educate
elicit8417203elicit_
elicited1139093elicited
elicits9311233elicits
elite56230183_elite
eluate62315433elu_ate
elucidate1265413elucidate
elusive1057003elusive
elute54822573elu__te
eluviate1146953eluviate
endite73817593endite
erudite838483erudite
eucaine939243eucaine
euchre11137663euchre
eucrites1049473eucrites
evite85317683_evite
excide1638423excide
excise1538553excise
excited1737853excited
exciter1637753exciter
excites16310633excites
facete115014833facete
faciae112913413faciae
facile112514883facile
finite9316823finite
flite85424963_flite
fluorite1147883fluorite
flute86823753flu__te
fomite113314073fomite
fuci95720313fuci__
fucose11167683fucose
furcate12310453furcate
fusile94313493fusile
futile93914953futile
gite55438613__gite
glaciate1168073glaciate
glucose1045113glucose
glute66020903glu__te
glycine1335713glycine
guide75019883gu_ide
guile64521133gu_ile
guise64717713gu_ise
gummite1236133gummite
gunites8313123gunites
halite93624233halite
huckle153913073huckle
humate113214443humate
ignite71410573ignite
illite63414913illite
incise83515323incise
incited103314623incited
inciter93113773inciter
incites93218483incites
indite73520313indite
invite93715023invite
iolite63221973iolite
jubile152910253jubile
jugate14379463jugate
juice14311323ju_ice
jute115327893ju__te
kite85338233__kite
kunzite2053503kunzite
labiate91313573labiate
labile8315213labile
lace66848473lac__e
lacier84020093lacier
lacily11612763lacily
lacing94626233lacing
lactate9312693lactate
lactic10713493lactic
lacune8169673lacune
laicise939333laicise
laicize1838093laicize
laith85722103l_aith
laity85318903l_aity
lamiae84817453lamiae
lanate6421263lanate
larine63927043larine
late47560483l__ate
latte55426303l_atte
lauwine1036373lauwine
lawine93316463lawine
laxity1637273laxity
lazulite1745033lazulite
lazurite1745243lazurite
lechwe1435113lechwe
lectin82515013lectin
legate72917453legate
legit61323503legit_
legits71313003legits
lenited8812433lenited
lenites7818443lenites
lenity9612713lenity
leucin839113leuci_n
leucines1037273leucines
leucins938103leucins
leucitic1245233leucitic
levity1277903levity
liaise6310693liaise
lice66045063l__ice
licente91210893licente
lichee114017973lichee
licht104723493licht_
lichted13268803lichted
lichts113712383lichts
licitly12276673licitly
lie38264523l__i_e
life75433733l__ife
ligate72519243ligate
lignite81310303lignite
like86040843l__ike
lime66244933l__ime
limit73126333limit_
limited102310233limited
limiter92710853limiter
limites92915453limites
limits82514133limits
line46965573l__ine
lipe66839733l__ipe
lipide93511063lipide
lire47845293l__ire
lit39377313l__it_
liter54736343l__iter
lithe84922013l__ithe
litre55421463l__itre
lits46252493l__its
litu47631563l__itu
live76540993l__ive
lobate82915243lobate
locale83915653locale
localite101411543localite
located103114183located
locater93113603locater
locates93218813locates
loci66126283loci__
locket123922473locket
locule83412033locule
loiter64619173l_oiter
looie55624243looi_e
lotte54923853l_otte
louche115212663louc_he
louie55023513loui_e
lube64731563lu__be
lubing94114033lubing
lucarne944263lucarne
lucence11147993lucence
lucent8313823lucent
lucern846103lucern
lucerne945753lucerne
luces75528433luc_es
lucidity1445493lucidity
lucidly13125213lucidly
lucifers1334163lucifers
luck105329823luc__k
lucked135118023lucked
luckier133811533luckier
luckies133313683luckies
luckily16297083luckily
lucking143615833lucking
lucks115723563luc_ks
lucky145515013luc_ky
lucres84513303lucres
lude55331643lu__de
ludic82912803ludi_c
luetic8310383luetic
luge55531643lu__ge
luggie8318903luggie
luging83915293luging
lumina84613543lumina
lunated8310823lunated
lune47140493lu__ne
lunet56835423lunet_
lunets66914763lunets
lunette737483lunette
lunge65323803lu_nge
lungee75119813lungee
lunier64617603lunier
lunies64723013lunies
lunt46148843lu_nt_
lunted74517523lu_nted
lunts55826903lu_nts
lunule638433lunule
lupin75215843lupi_n
lupines93912503lupines
lupins84514463lupins
lure45142463lu__re
lurid64618973luri_d
luring73820753luring
lust47442603lu_st_
lusted74319443lu_sted
luster64023673lu_ster
lustier73813503lustier
lustre64011683lustre
lusts55022803lu_sts
lusty85417573lu_sty
lutea54819073lu__tea
luted64826143lu__ted
lutes55836663lu__tes
luting75221753luting
lutist64317553lutist
lutists73810273lutists
lutz136826323lu__tz
luxated1535713luxated
luxates1436973luxates
luxe115222693lu__xe
lycee104716743lyc_ee
lychee143710893lychee
lyddite1243333lyddite
lyrate94112103lyrate
lysate9388103lysate
lysine94210553lysine
miscite11314383miscite
mite66249403__mite
mucid104115253muci_d
mucin93116823muci_n
mucins102712513mucins
muckle143413583muckle
mucose10149313mucose
mullite9313013mullite
muriate9313363muriate
murine84220023murine
mutate83017483mutate
mute65136873mu__te
mutine84420373mutine
nite45943583__nite
norite63221133norite
nubile83212703nubile
nuchae11218513nuchae
nuclide1037173nuclide
nudie65118673nudi_e
nudity1037993nudity
nutate63017373nutate
oocyte1135753oocyte
oolite63319603oolite
ophite11410563ophite
oscine8311563oscine
ourie54027293ouri_e
outate62923403outate
outcity1238453outcity
paucity1435823paucity
pelite84323003pelite
petite84320653petite
picrite111911313picrite
pinite8321243pinite
placate11312433placate
plicate11314513plicate
plumate1149803plumate
podite93315353podite
polite83625073polite
puce85127883puc__e
pumice1238223pumice
pumicite1446813pumicite
pupate104213123pupate
purine85321893purine
purity114114913purity
puttie84116303puttie
pyrite11913313pyrite
quarte154115323quarte
quate144521413qu_ate
qubit164218983qubit_
qubits173710343qubits
qubyte2034243qubyte
quiche2057903quiche
quiet144530733qu_iet
quinte153414523quinte
quire144917123qu_ire
quit136136513qu_it_
quits144122353qu_its
quoit143819863quoit_
quoited1756403quoited
quoits15379683quoits
quote143714773qu_ote
ratite65022423ratite
raucity1235853raucity
recipe103414893recipe
recit75235103recit_
recited104319103recited
reciter94117263reciter
recites93524583recites
recits83621353recits
resite64128453resite
reunite7312713reunite
rite45849453__rite
ruche104216763ruc_he
ruckle124414583ruckle
rugate75813813rugate
rusine63916593rusine
rutile65217683rutile
samite83020603samite
scute75520943_scute
site47052413__site
skite95120043_skite
sluice849513slu_ice
smite75224863_smite
somite84519373somite
sopite84917713sopite
spite75430663_spite
sprite84421773sprite
subitem1138543subitem
subito8410443subito
subsite9412863subsite
suckle124015963suckle
sucre75019103suc_re
suicide1038893suicide
suit45649873su_it_
suited74019423su_ited
suiter64121813su_iter
suites63727403su_ites
suits55028053su_its
sulcate9314423sulcate
sulfite10310473sulfite
supine84216693supine
tacit76333673tacit_
taxite13511303taxite
tectite9310583tectite
trite54730033_trite
tubate82813173tubate
tucket124219483tucket
turgite837973turgite
ulexite1445723ulexite
ululate749963ululate
unciae83215313unciae
uncute82912133uncute
unit45140073_unit_
united74421543_united
uniter64619143_uniter
unites65024853_unites
units54923433_units
unity84918493_unity
untie54425493_untie
urate55432163_urate
urine55026593_urine
ute35335883_u__te
utile54718933_utile
vacate11314553vacate
verite94323443verite
white114920303_white
wite75443273__wite
write85522833_write
zincite1837233zincite

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 Filter1786911127160.186960704.3
2DLD Change Limit1127164427.65614722.6
3Display Results4424420.1862376.3
 (SQL Overall)1786914428.02822258.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.