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

505 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
albites931320(None) 
albite8313311albite_
abates85825032a_bates
abides94719892a_bides
ablates92416902ablates
alates64833972al_ates
albatas938372albatas
albinos937652albinos
albitic1139132albitic
alibies9313322alibies
alines65735222al_ines
alkies104518092alki_es
alkines114415732alkines
allies63827672alli_es
alpines94016192alpines
alsikes1137262alsikes
alunites8310702alunites
ambits103713412ambit_s
aplites9314932aplites
arbiter939932arbiter
arbiters1038852arbiters
arbutes939702arbutes
ascites9312602ascites
augites8312182augites
axites134913832a_xites
bites75641172__bites
blites84721212bl_ites
calcites12313002calcites
elites66027122el_ites
flites95122442fl_ites
halites103221192hal_ites
illites72415012illites
labiates101011512labiates
abases85720773a_bases
abate76627843a_bate_
abated95918453a_bated
abater85518123a_bater
abaters95115203a_baters
abatis84317933a_batis
abbes96723523a_b_bes
abbots1039283abbot_s
abeles84719393a_beles
abets75621673a_bet_s
abide86223713a_bide_
abided105313313a_bided
abider95314463a_bider
abiders104011083a_biders
abioses9311493a_bioses
ablate82219213ablate_
ablated102513443ablated
ables75935543a_b_les
ablings1038743ablings
ablins8316193abli_ns
abluted10188363abluted
abodes94417513a_bodes
aboves114512843a_boves
abuses85119103a_buses
abuts75417073a_but_s
abyes105518533a_b_yes
achiotes1339003achiotes
aconites10314353aconites
actives12311523actives
acuities10312453acuities
acutes83917723a_cutes
adits66523713a_dit_s
admires1038663admires
admits9411413admit_s
admixes1765963admixes
advices13136933advices
advises11138973advises
aediles83413903aediles
aegises8311373aegises
aerates74627493aerates
aeries64737783aeri_es
affines1339483affines
affixes2035503affixes
afrits9311903afrit_s
agates76121343a_gates
aggies83515513aggi_es
agitas7310593a_gitas
agnates82813193agnates
agnizes17328843agnizes
aides65336603a__ides
aits46355533a__it_s
alanines8314803alanines
alants67722023alant_s
alate55340333al_ate_
alated75625153al_ated
albas75925393alb__as
albata839333albat_a
albedoes1184533albedoes
albedos1075253albedos
albeit8314343albeit__
albertites1244873albertites
albicores1343523albicores
albinal937813albinal
albinic1136853albinic
albinism1276413albinism
albino839933albi_no
albizia1864093albizia
albizias1973533albizias
albs68628573alb___s
albumen1135243albumen
albumens1244143albumens
albums10198273alb_ums
alcades101011473alcades
alcaides11117673alcaides
alcids94812293alci_ds
alcoves1297883alcoves
aldoses8311203aldoses
alerted82512223alerted
alerter72111513alerter
alertest8310173alertest
alerts64418223alert_s
ales47067103al___es
alewives1444283alewives
alexines15258503alexines
alginates10310123alginates
algins74816433algi_ns
alias55834603al_i_as
aliases7914493aliases
alibied1038143alibied
alibis8311073al_ibis
alible8311973alible_
alien56425583al_i_en
aliens65619213al_iens
alifs86121263al_i_fs
aligns75312953al_igns
alike95523963al_ike_
aline57243153al_ine_
alined75221403al_ined
aliner65621983al_iner
aliners74717723al_iners
aliped95414283al_iped
alipeds10386793al_ipeds
alit46155693al_it__
alive85722513al_ive_
aliyas93911803al_iyas
aliyos9349533al_iyos
alkanes113812933alkanes
alkenes114212753alkenes
alkie95520033alki_e_
alkine104916803alkine_
alkynes14336463alkynes
allanites949803allanites
allees64521483al_lees
alleges84212573alleges
alleles73812033alleles
allied74217153alli_ed
alliums957973alliums
allots64019173allot_s
alludes83610333alludes
allures72913113allures
almes75126543al__mes
almuces11316823almuces
almudes10418263almudes
alnicos985533alnicos
aloes54933673al__oes
aloins65022203aloi_ns
alpine84417373alpine_
alsike1047913alsike_
alter54828503al__ter
alters64924223al__ters
altitudes10196583altitudes
altos55822953al__tos
alts46639903al__t_s
alumines10411683alumines
alunite7311633alunite_
alvine94614583alvine_
ambages1269623ambages
ambit94223713ambit__
ambles105121863amb_les
ambones11312683ambones
ambries111614553ambries
amices105018013a_mices
amides95722663a_mides
amies76837693a_mi_es
amines84727983a_mines
amities9317383a_mities
ammines11312673ammines
amniotes1036603amniotes
amosites10311233amosites
amritas939093amritas
analcites1147483analcites
animes84719593a_nimes
anises64826693a_nises
annates72415423annates
antes56334323a__ntes
apatites10311293apatites
aphides134711203aphides
apices104916263a_pices
aplite8316393aplite_
apsides103911303apsides
arabizes1969103arabizes
arbitress1143853arbitress
arbores94016033arbores
arbute8311043arbute_
arbutus944843arbutus
arenites8917103arenites
aretes64425353a_retes
arises65233803a_rises
armies85123693armi_es
arrises71617583arrises
arrives101311513arrives
arsines73518813arsines
artistes83213343artistes
asides75118873a_sides
aspires9612043aspires
aspises9611643aspises
assizes1638453assizes
ates45047923a___tes
atlantes838553atlantes
attires72312953attires
attrites8311563attrites
aubades1038753aubades
audiles83112613audiles
audited939033audited
auditee8311573auditee
auditees946463auditees
audits72814113audit_s
augite7312613augite_
aunties73920073aunties
aviates10313063aviates
awaited1146963awaited
awaiter1057443awaiter
awaiters1146643awaiters
awaits96411953await_s
axises134413993a_xises
axite125218253a_xite_
azides165113803a_zides
azines155517073a_zines
azotes154312223a_zotes
azurites1737283azurites
babbitts1144023babbitts
babies106123653babi_es
backbites19108633backbites
baldies105317703baldi_es
ballies93725743balli_es
ballutes1037523ballutes
barbies114519593barbi_es
barites94322333barites
bates75846343__bates
bauxites1735153bauxites
bices95029963__bices
bides85536773__bides
bikes117529473__bikes
bilbies114712343bilbi_es
biles75542143__biles
bines76946793__bines
bises75435623__bises
bite66547003__bite_
biter75030033__biter
biters83925243__biters
bits66148163__bit_s
bitts75022593__bitts
bizes165923663__bizes
blite76225353bl_ite_
blitzes18408703bl_itzes
boites84322703_boites
butes714535873__butes
bytes105217493__bytes
cabbies133115163cabbi_es
calamites13410713calamites
calcines12314753calcines
calcite11413783calcite_
calibres1237103calibres
calices114321693cal_ices
calottes10610083calottes
calvities1438943calvities
carbides133111693carbides
carbines123617543carbines
cerites94823433cerites
cites74435593__cites
climes104720003cl_imes
clines84926043cl_ines
cubits103714033cubit_s
cubitus11346783cubitus
curites93919863curites
dacites101114593dacites
dallies84023193dalli_es
darbies104216983darbi_es
debates103718533debates
debited113311623debited
debits94214503debit_s
dites66339153__dites
dobies94422093dobi_es
dunites8313593dunites
egalites9310503egal_ites
elates65032363el_ates
elides74420693el_ides
elite56230183el_ite_
eluates72014683eluates
elutes64020313el_utes
endites83717063endites
equites162212493equites
evites94916473_evites
excites16310633excites
falsies103515013falsi_es
falsities1248133falsities
felsites1138073felsites
finites10315923finites
fleabites1443613fleabites
flies85630713fl_i_es
flite85424963fl_ite_
flited104616583fl_ited
flits85625223fl_it_s
flutes95421783fl_utes
flytes123911563fl_ytes
fomites123613203fomites
frites94922483_frites
gabies93820733gabi_es
gahnites1235703gahnites
galenites10129183galenites
galettes93111163galettes
gallates92815533gallates
gallies84122713galli_es
gambits12399723gambit_s
gites65630183__gites
glaires84010143glaires
glaives11347833glaives
glides84518863gl_ides
glimes94717523gl_imes
glitzes17367563gl_itzes
glutes74517673gl_utes
gobies95418063gobi_es
gunites8313123gunites
habited1337883habited
habits113014653habit_s
habitues13306413habitues
habitus12338173habitus
halides113416663hal_ides
halite93624233hal_ite_
halitus10339963hal_itus
haplites1339993haplites
hyalites14208833hyal_ites
ibices10398163_ibices
ibises83610543_ibises
ignites81310583ignites
ileitis738063ileitis
illite63414923illite_
imbibes1334693imbibes
incites93218483incites
indites83618983indites
invites103915813invites
iolites73819483iolites
jadeites1645823jadeites
jubiles16289373jubiles
kainites1238793kainites
kibitzes2342863kibitzes
kites95432543__kites
labials9299873labials
labiate91313573labiate_
labiated11109303labiated
labile8315223labile_
laborites1149263laborites
labrets939363labrets
ladies75124883ladi_es
laities7320343_laities
lambies113015113lambi_es
lapides103012043lapides
lapises93513463lapises
latices9313763latices
lattes65324203_lattes
lawines103313563lawines
laxities1539093laxities
lazies154418783lazi_es
lenites7818443lenites
lies46454193_l_i_es
likes96231903_l_ikes
limes75636503_l_imes
limites92915453limites
lines57054573_l_ines
litas54923773_l_itas
lite47054543_l_ite_
liter54736343_l_iter
liters65429883_l_iters
litres65220393_l_itres
lits46252493_l_it_s
lives86133193_l_ives
loiter64619173_loiter
loiters74116613_loiters
lottes65322753_lottes
lucites9311863lucites
lutes55836663_l_utes
malaises10312333malaises
malates93522613mal_ates
maleates103316343maleates
malices114316623mal_ices
malines93625603mal_ines
mannites10312613mannites
marlites103415263marlites
marmites122212793marmites
mites75141803__mites
mobiles112813123mobiles
mullites10411643mullites
nailbiter1142673nailbiter
nailbiters1242053nailbiters
niobites1037313niobites
nites55736343__nites
norites74018803norites
obits74617553_obit_s
oblates91913243oblates
obliges1037143obliges
oldies7314423oldi_es
oleates7417833oleates
oleines7313393oleines
olives94313953ol_ives
oolites72817843oolites
ophites12310103ophites
orbited1037733orbited
orbiter937853orbiter
orbiters1036593orbiters
orbits84211443orbit_s
palates93624943pal_ates
palettes103112833palettes
palliates11311033palliates
palpates122613063palpates
palsies94420273palsi_es
pelites93821993pelites
petites93820203petites
pinites9319533pinites
plaices11411143plaices
plaited103713893plaited
plaiter93615393plaiter
plaiters103512633plaiters
plaits83816473plait_s
plates85432243pl_ates
platies93722543platies
plies74526513pl_i_es
podites103014733podites
pyrites12812203pyrites
qubits173710353qubit_s
qubytes2134383qubytes
rabbies113416053rabbi_es
rabbited1334763rabbited
rabbiter1234673rabbiter
rabbiters1343733rabbiters
rabbits11299863rabbit_s
rabies85226023rabi_es
rallies73823343ralli_es
ratites74920683ratites
rebates95123183rebates
recites93524583recites
resites74027793resites
rites54442553__rites
rubies84420343rubi_es
sabines94318483sabines
salines74029413sal_ines
sallies73227813salli_es
salties73725773salti_es
saltines82917793saltines
saltires83112433saltires
salutes73716253sal_utes
samites93118713samites
sites56045433__sites
skites104418043_skites
slates64934063sl_ates
slices84022853sl_ices
slides73922183sl_ides
slimes84722043sl_imes
slipes84921413sl_ipes
slits56128853sl_it_s
sluices959073sluices
smaltites1145743smaltites
smites83921923_smites
somites94219123somites
sopites93817173sopites
sorites73825243sorites
spites84127333_spites
sprites94220333sprites
stilbites1144833stilbites
subitem1138553subitem
subitems1245493subitems
subsites10312783subsites
suites63727403_suites
sulfites1139903sulfites
sylvites14225843sylvites
tabbies112913503tabbi_es
tabbises12236523tabbises
talipes9611603tal_ipes
talkies113415733talki_es
tallies73624603talli_es
tallises82713263tallises
tallithes12286583tallithes
talliths11377433talliths
tallits73215993tallit_s
taxites1449673taxites
tillites8312833tillites
tobies84521023tobi_es
ulexites1534943ulexites
unites65024853_unites
uralites82112723ural_ites
valines104520213val_ines
valises103516263val_ises
valuates112811203valuates
velites103417303velites
verites103822263verites
walies95324523wal_i_es
wallies103320743walli_es
websites1335183websites
whites123919883_whites
wites85536963__wites
writes94420333_writes
yabbies14279643yabbi_es
zloties1639913zloties

Search took 10 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.423422437.4
2DLD Change Limit1340275058.73315347.2
3Display Results5055050.2032487.7
 (SQL Overall)1786915059.35919093.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.