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

294 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
albeit831434(None) 
abet610547942a_be_t
ableist9311772ableist
ablest84721832ablest
albedo956122albedo
albite8313312alb_ite
alert54740652al_ert
alit46155692al__it
ambit94223712amb_it
halbert12314502halbert
sobeit8315362sobeit
abaft10318063a_baft
abbe87627193abbe__
abbes96723523abbe_s
abbess10509773abbess
abbey125714933abbe_y
abbeys13538423abbeys
abbot9318453a_bbot
abeam9316533a_beam
abed79734133a_be_d
abele76323253a_bele
abelia83114403a_belia
abets75621673a_bets
abject17137703abject
ablaut8313263ablaut
able66340533able__
abled86926833able_d
ableism1136823ableism
ableists1036543ableists
abler75624313able_r
ables75935543able_s
abluent939623abluent
aboil72217543a_boil
abort76133583a_bort
about75229083a_bout
abri65522213a_bri_
abris75722603a_bris
abseil837183abseil
absent84016993absent
abut66834953a_b_ut
accent105116263accent
accept123210623accept
acquit17610323acquit
adept81219643a_dept
adit56443653a__dit
admit8319493a_dmit
adroit7518793adroit
advect12309123advect
advent102613753advent
advert103215783advert
affect1448903affect
afreet9315153afreet
afrit8323173a_frit
ageist7315383a_geist
agent65829643a_gent
aglet65534143agle_t
ailment9314233ailment
airest63825263airest
ait38093903a___it
alae45643753alae__
alanin6317273alanin
alant55742293al_ant
alb57342653alb___
alba68328333alb__a
albas75925393alb_as
albata839333albata
albedos1075253albedos
albertite1146123albertite
albinic1136853albinic
albino839933albino
albites9313203alb_ites
albitic1139133albitic
albizia1864093albizia
albs68628573alb__s
album92312653alb_um
albumin1145563albumin
albums10198273albums
alcaic1039983alcaic
alcid85817973al_cid
alder65421913alde_r
alders74218423alders
aldrin7311243aldrin
ale36572343al_e__
alec66430063al_e_c
alecs76620733al_ecs
alee46652323al_e_e
alef76340693al_e_f
alefs87319663al_efs
aleph10311393al_eph
alerts64418223al_erts
ales47067103al_e_s
alevin92511513alevin
alexia132910463alexia
alexin132311483alexin
algid75415583al_gid
algin65718763al_gin
algoid83011473algoid
alibi7514233alibi_
alibied1038143alibied
alibies9313323alibies
alibis8311073alibis
alien56425583alie_n
alienist8411993alienist
aliens65619213aliens
alif76242143al__if
alight103816863alight
aliment9316703aliment
alist56136783al_ist
aliyot93611713aliyot
alkene104114003alkene
alkie95520033al_kie
alkies104518093alkies
allee54932123alle_e
allees64521483allees
allege74314653allege
allele64514563allele
allelic9118173allelic
alley85721673alle_y
alleys95113303alleys
allied74217153allied
allies63827673allies
allot54933873al_lot
alme65832163alme__
almeh106214553alme_h
almehs11619493almehs
almes75126543alme_s
almost81014433almost
alodia71112453alodia
aloe45540193aloe__
aloes54933673aloe_s
aloetic9313183aloetic
aloft8423433al_oft
aloin55227423al_oin
alt36467963al___t
alter54828503alte_r
alterity1149843alterity
alters64924223alters
altoist7313393altoist
alumin8513543alumin
alunite7311633alunite
ambeer104511603ambeer
amber94523213ambe_r
ambers104519583ambers
ambery133811133ambery
ambient11310093ambient
ambits103713413amb_its
amebic1239113amebic
ament76036543a_ment
anent54931843a_nent
apneic1078623apneic
aptest82917513aptest
ardent73022613ardent
areic73219393a_reic
argent74023663argent
armet76739453arme_t
armpit10811093armpit
arpent84822093arpent
arrest63722633arrest
ascent84519653ascent
aspect10612823aspect
assent65119953assent
assert64922583assert
asset55932263asse_t
atheist10314063atheist
attent62818323attent
attest62618613attest
attrit6315753attrit
audit62527883a_udit
auldest839893auldest
aurei54821863aurei_
avert86029493a_vert
await85524493a_wait
bait66556003__bait
baldest102313533baldest
ballet84733973balle_t
barbet104427883barbe_t
beat66168303__beat
beet66457543__beet
befit105222663__befit
belt65754033__belt
bent67759913__bent
best66355323__best
bet58376673__be_t
bit57070903__b_it
bleat75737003bl_eat
blent76230953bl_ent
blest76431723bl_est
blet66247673bl_e_t
bluest84016483bluest
bluet75631193blue_t
brit66350153__brit
cablet104429463cable_t
callet84536763calle_t
calmest11312343calmest
cleat76335063cl_eat
cleft106222853cl_eft
clept95725773cl_ept
client8316343client
cubit94122893cub_it
debit85727853deb_it
deceit93018213deceit
ebbet93517293ebbe_t
eldest72912683eldest
elect74327033el_ect
elegit71212893elegit
elicit8417203elicit
eluent6315483eluent
fabbest1438033fabbest
falsest10310013falsest
filbert12411643filbert
fleet85932333fl_eet
fliest94718433fliest
flit76539273fl__it
fluent9313933fluent
flybelt1594453flybelt
gallein8299043gallein
gallet73630853galle_t
gambit114714213gamb_it
gilbert10310763gilbert
gleet65532343gl_eet
habit103027023hab_it
halberd1336053halberd
halberts1335973halberts
halest94823273hal_est
hobbit132810543hobbit
howbeit1545663howbeit
illest63615723illest
jailbait1744063jailbait
kibei114311533kibei_
kibeis12469803kibeis
label75019383labe_l
labels84515683labels
labia75219013lab_ia
labret8320223labret
lambent113711303lambent
lambert113617113lambert
lament85024943lament
lamest84722763lamest
latent64124303latent
latest63822703latest
laxest134913363laxest
leet45957903_l_eet
left76340483_l_eft
legit61323503_legit
lei36846383_l_ei_
leis45739603_l_eis
lent46360533_l_ent
lept66440883_l_ept
lest46956323_l_est
let36481473_l_e_t
licit74327683_licit
limit73126343_limit
lit39377313_l__it
lwei75312643_lwei_
lweis8458693_lweis
mallei84414633mallei_
mallet84433053malle_t
obit66837083_ob_it
oldest72114093oldest
oleic7313333ol_eic
olein5316003ol_ein
orbit73622063orb_it
palest83926223pal_est
palet74650803pal_e_t
paliest93021613paliest
pallet84232653palle_t
plait75631573pl_ait
pleat74734473pl_eat
qubit164218993qub_it
rabbet103818653rabbe_t
rabbit102914563rabbit
rarebit948423rarebit
rebait8320403rebait
salient7419763salient
sallet63734543salle_t
saltest71916513saltest
sleekit1145453sleekit
sleet55639133sl_eet
slept75728103sl_ept
sliest66621963sliest
slit46250103sl__it
slyest93811363slyest
subedit1049403subedit
submit10312673submit
tablet84227643table_t
talent6323323tal_ent
tallest7317093tallest
tallit63422733tal_lit
unbelt83015693unbelt
unbent83216593unbent
upbeat10911513upbeat
valet84337873val_e_t
wallet93327093walle_t
zibet16419733zibe_t

Search took 6 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.516346300.4
2DLD Change Limit1127162944.95322757.1
3Display Results2942940.0933161.3
 (SQL Overall)1786912945.56232127.1
 
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.