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

512 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
albite831331(None) 
albites9313201albites
abate76627842a_bate
abide86223712a_bide
ablate82219212ablate
alate55340322al_ate
albata839332albata
albeit8314342albeit_
albino839932albino
albitic1139132albitic
alible8311972alible
alike95523962al_ike
aline57243152al_ine
alit46155692al_it_
alive85722512al_ive
alkie95520032alki_e
alkine104916802alkine
alpine84417372alpine
alsike1047912alsike
alunite7311632alunite
alvine94614582alvine
ambit94223712ambit_
ambits103713412ambits
aplite8316392aplite
arbiter939932arbiter
arbute8311042arbute
augite7312612augite
axite125218252a_xite
bite66547002__bite
blite76225352bl_ite
calcite11413782calcite
elite56230182el_ite
flite85424962fl_ite
halite93624232hal_ite
illite63414922illite
labiate91313572labiate
labile8315222labile
lite47054542_l_ite
abase76023483a_base
abated95918453a_bated
abater85518123a_bater
abates85825033a_bates
abbe87627193a_b_be
abbot9318453abbot_
abbots1039283abbots
abele76323253a_bele
abet610547943a_bet_
abets75621673a_bets
abided105313313a_bided
abider95314463a_bider
abides94719893a_bides
ablated102513443ablated
ablates92416903ablates
ablaze17239833ablaze
able66340533a_b_le
ablins8316193ablins
abluted10188363abluted
abode85518813a_bode
above105414323a_bove
abuse77119563a_buse
abut66834953a_but_
abuts75417073a_buts
abye97921003a_b_ye
achiote1239213achiote
aconite9315473aconite
active11313743active
acuate8315633acuate
acuity1139373acuity
acute74720363a_cute
adit56443653a_dit_
adits66523713a_dits
admire949933admire
admit8319493admit_
admits9411413admits
adnate72913483adnate
advice12107883advice
advise10139223advise
aedile73716653aedile
aedine73218393aedine
aerate64830553aerate
aerie54634603aeri_e
affine12310503affine
afire86215913a_fire
afrit8323173afrit_
afrits9311903afrits
agate66525153a_gate
aggie73415013aggi_e
agile65122263a_gile
agita6315423a_gita
agnate73314883agnate
agnize16329563agnize
aide56045003a__ide
ait38093903a__it_
aits46355533a__its
alae45643753al__ae
alane56135613al_ane
alanine7316863alanine
alant55742293alant_
alants67722023alants
alated75625143al_ated
alates64833963al_ates
alb57342653alb___
alba68328333alb__a
albas75925393alb_as
albatas938373albatas
albedo956123albedo
albertite1146123albertite
albicore1243703albicore
albinal937813albinal
albinic1136853albinic
albinos937653albinos
albizia1864093albizia
albs68628573alb__s
album92312653alb_um
albumen1135243albumen
albums10198273albums
alcade91111513alcade
alcaide1088453alcaide
alcid85817973alci_d
alcids94812293alcids
alcove1178083alcove
aldose7311093aldose
ale36572343al___e
alee46652323al__ee
alert54740653alert_
alerted82512223alerted
alerter72111513alerter
alerts64418223alerts
alewife1344923alewife
alexine142410543alexine
algae65319623al_gae
algid75415583algi_d
algin65718763algi_n
alginate9310693alginate
algins74816433algins
alias55834603al_ias
alibi7514233al_ibi
alibied1038143alibied
alibies9313323alibies
alibis8311073alibis
alien56425583al_ien
alif76242143al_i_f
alifs86121263al_ifs
align65016503al_ign
alined75221403al_ined
aliner65621983al_iner
alines65735223al_ines
aliped95414283al_iped
alist56136783al_ist
aliya83713483al_iya
alkane104313323alkane
alkene104114003alkene
alkies104518093alkies
alkines114415733alkines
alkyne13436863alkyne
allanite8411093allanite
allee54932123al_lee
allege74314653allege
allele64514563allele
allied74217153allied
allies63827673allies
allium8311243allium
allot54933873allot_
allots64019173allots
allude73910903allude
allure63012943allure
alme65832163al__me
almuce10348213almuce
almude9399933almude
alnico877943alnico
aloe45540193al__oe
aloft8423433aloft_
aloin55227423aloi_n
aloins65022203aloins
alone55732963al_one
alpines94016193alpines
alsikes1137263alsikes
alt36467963al__t_
alter54828503al__ter
altitude9166673altitude
alto47831263al__to
alts46639903al__ts
alulae6312743alulae
alumine9412693alumine
alunites8310703alunites
ambage11510603ambage
amble95924643amb_le
amice96122873a_mice
amide86128483a_mide
amie66339853a_mi_e
amine75835383a_mine
amity10416093a_mity
ammine10314493ammine
amniote936963amniote
amosite9313163amosite
amrita8411133amrita
analcite1049333analcite
anile54634463a_nile
anime75423203a_nime
anise55129703a_nise
ansate64517863ansate
ante46538903a__nte
apatite9312963apatite
aplites9314933aplites
arabize1849343arabize
arbiters1038853arbiters
arbutes939703arbutes
arenite71017713arenite
arete56031353a_rete
arise56436433a_rise
arrive91311793arrive
arsine64021043arsine
artiste73813693artiste
ascites9312603ascites
aside65122083a_side
aspire8612123aspire
assize1538633assize
astute6310763astute
ate37059243a___te
attire62412383attire
attrite7311833attrite
aubade939223aubade
audile73315303audile
audit62527883audit_
audited939033audited
auditee8311573auditee
audits72814113audits
augites8312183augites
auntie64317703auntie
aurate64426473aurate
aviate9315203aviate
await85524493await_
awaited1146963awaited
awaiter1057443awaiter
awaits96411953awaits
awhile1257793awhile
axile126020513a_xile
axites134913833a_xites
axlike17388853axlike
azide155617163a_zide
azine146721413a_zine
azote144416343a_zote
azurite1638003azurite
babbitt1038033babbitt
backbite1899173backbite
ballute938543ballute
barbate11314543barbate
barbie105018353barbi_e
barite84224813barite
bate66552423__bate
bauxite1635573bauxite
bice86235563__bice
bide76041503__bide
bike106532603__bike
bile66147183__bile
bine66650863__bine
bise66437103__bise
bit57070903__bit_
biter75030033__biter
bites75641173__bites
bits66148163__bits
bitt65545813__bitt
bize155926293__bize
blate75933783bl_ate
blites84721213bl_ites
blithe115810863bl_ithe
blitz165318133bl_itz
boite74426323_boite
bute66739673__bute
byte96521813__byte
cabbie122913353cabbi_e
calamite12312533calamite
calcine11315273calcine
calcites12313003calcites
calibre1136603calibre
calotte9510563calotte
carbide126112493carbide
carbine112918643carbine
cerite84724873cerite
cite65640343__cite
clime95720893cl_ime
cline76428533cl_ine
cubit94122893cubit_
cubiti10399083cubiti
cubits103714033cubits
curite85222943curite
dacite91115883dacite
debate94419193debate
debit85727853debit_
debited113311623debited
debits94214503debits
dite55547553__dite
dobie84920333dobi_e
dunite7315013dunite
egalite8311563egal_ite
elate55335883el_ate
elide64922643el_ide
elites66027123el_ites
eluate62315433eluate
elute54822573el_ute
endite73817593endite
evite85317683_evite
excite15310883excite
falcate12311613falcate
falsie93513853falsi_e
falsity1335903falsity
felsite1039083felsite
finite9316823finite
fleabite1354163fleabite
flit76539273fl_it_
flited104616583fl_ited
flites95122443fl_ites
flits85625223fl_its
flute86823753fl_ute
flyte115713943fl_yte
fomite113314073fomite
gahnite1135973gahnite
galeate83916783galeate
galenite91210063galenite
galette84212693galette
gallate83417123gallate
gambit114714213gambit_
gambits12399723gambits
gite55438613__gite
glaire74411293glaire
glaive10357933glaive
glide74521593gl_ide
glime85620193gl_ime
glitz154916373gl_itz
globate1057823globate
glute66020903gl_ute
gunite7414403gunite
habile11515213habile
habit103027023habit_
habited1337883habited
habits113014653habits
habitue12266703habitue
halide103417993hal_ide
halites103221193hal_ites
haplite12310703haplite
hyalite13229473hyal_ite
ignite71410583ignite
illites72415013illites
imbibe1234703imbibe
incite83618733incite
indite73520323indite
invite93715033invite
iolite63221983iolite
jadeite1546403jadeite
jubile152910263jubile
kainite1149543kainite
kibitz2177643kibitz
kite85338243__kite
labia75219013labi_a
labial84714343labial
labiated11109303labiated
labiates101011513labiates
labium10410243labium
laborite10410693laborite
labret8320223labret
laith85722103_laith
laity85318903_laity
lambie103213673lambi_e
lamiae84817453lamiae
lanate6421263lanate
larine63927043larine
late47560483_l_ate
latte55426303_latte
lawine93316463lawine
laxity1637273laxity
lenite6719983lenite
lice66045063_l_ice
lie38264523_l_i_e
life75433733_l_ife
like86040843_l_ike
lime66244933_l_ime
line46965573_l_ine
lipe66839733_l_ipe
lire47845293_l_ire
lit39377313_l_it_
liter54736343_l_iter
lithe84922013_l_ithe
litre55421463_l_itre
lits46252493_l_its
litu47631563_l_itu
live76540993_l_ive
lobate82915243lobate
loiter64619173_loiter
lotte54923853_lotte
lucite8313343lucite
lute46341013_l_ute
malaise9312673malaise
malate84624553mal_ate
maleate94117543maleate
malice104818483mal_ice
maline84529083mal_ine
mannite9312903mannite
marlite92917073marlite
marmite112413993marmite
mite66249413__mite
mobile103613543mobile
mullite9313013mullite
nailbiter1142673nailbiter
niobite937953niobite
nite45943583__nite
norite63221133norite
nubile83212713nubile
obit66837083_obit_
obits74617553_obits
oblate82214743oblate
oblige937653oblige
oldie6415473oldi_e
oleate6318883oleate
oleine6313793oleine
olive84817153ol_ive
oolite63319603oolite
ophite11410563ophite
orbit73622063orbit_
orbited1037733orbited
orbiter937853orbiter
orbits84211443orbits
palate84226783pal_ate
paleate94120003paleate
palette93613983palette
palliate10311893palliate
palmate113215233palmate
palpate113213923palpate
partite9317133partite
pelite84323003pelite
petite84320653petite
pinite8321243pinite
plaice10311553plaice
plait75631573plait_
plaited103713893plaited
plaiter93615393plaiter
plaits83816473plaits
plate74635113pl_ate
plie65127393pl_i_e
podite93315353podite
polite83625073polite
pyrite11913313pyrite
qubit164218993qubit_
qubits173710353qubits
qubyte2034243qubyte
quite144621463_quite
rabbit102914563rabbit_
rabbited1334763rabbited
rabbiter1234673rabbiter
rabbits11299863rabbits
rabbity14266303rabbity
ralline73518413ralline
ratite65022423ratite
rebate84424113rebate
recite83625113recite
resite64128453resite
rite45849453__rite
sabine84020393sabine
saline65132703sal_ine
saltie63422433salti_e
saltine75018563saltine
saltire73113033saltire
salute64418023sal_ute
samite83020603samite
site47052413__site
skite95120053_skite
slainte738543slainte
slate55438283sl_ate
slice74925823sl_ice
slide64725413sl_ide
slime74925753sl_ime
slipe75626133sl_ipe
slit46250103sl_it_
slits56128853sl_its
sluice849513sluice
smaltite1046903smaltite
smite75224873_smite
somite84519373somite
sopite84917713sopite
spite75430663_spite
sprite84421773sprite
stilbite1045423stilbite
subitem1138553subitem
subito8410453subito
subsite9412873subsite
suite54829563_suite
sulfite10310473sulfite
sylvite13266353sylvite
talkie103914443talki_e
tallit63422733tallit_
tallith102913063tallith
tallits73215993tallits
taxite13511303taxite
tibiae838483tibiae
tillite7313563tillite
trite54730033_trite
tubate82813173tubate
ulexite1445723ulexite
unite54828383_unite
uralite71714103ural_ite
valine94623093val_ine
valise92917643val_ise
vallate103016563vallate
valuate102512733valuate
valvate133710813valvate
verite94323443verite
wallie93216803walli_e
website1235323website
white114920303_white
wite75443273__wite
write85522833_write
yabbie13308663yabbi_e
zlote143912943zl_ote

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 Filter1786911127160.373479064.3
2DLD Change Limit1127165125.68619823.4
3Display Results5125120.1563282.1
 (SQL Overall)1786915126.21528751.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.