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

360 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
allele6451456(None) 
allee54932121alle_e
allege74314651allege
alleles73812031alleles
abele76323252a_bele
aglee65728492agle_e
alee46652322a_le_e
alible8311972alible
alkene104114002alkene
allees64521482allees
alleged9389322alleged
alleger8319632alleger
alleges84212572alleges
allelic9118172allelic
alley85721672alle_y
alleys95113302alleys
allude73910902allude
allure63012942allure
allyl85310542allyl_
allyls9437272allyls
anele55628832a_nele
callee84327292calle_e
hallel93514092hallel_
hallels103310132hallels
mallee84525592malle_e
walleye1336242walleye
abeles84719393a_beles
ablate82219213ablate
ablaze17239833ablaze
able66340533a__ble
abled86926833able_d
abler75624313able_r
ables75935543able_s
ablest84721833ablest
accede1138303accede
achene11313813achene
ackee115825373acke_e
addle74318353a_ddle
adhere10310333adhere
aedile73716653aedile
afield1035953afield
aflame1138723aflame
agee56241493a_ge_e
agene65621583a_gene
agile65122263a_gile
agilely1135123agilely
aglare7312423aglare
agleam9158623agleam
aglet65534143agle_t
aglets73915683aglets
agley96917333agle_y
agree65226033agre_e
ailed66240283aile_d
aisle55223193a_isle
ajee115928233a_je_e
akee85936813a_ke_e
akela9311343a_kela
akene95818663a_kene
alae45643753a_l_ae
alane56135613a_lane
alate55340323a_late
albedo956123albedo
albeit8314343albeit
albite8313313albite
alcade91111513alcade
alcalde10104953alcalde
alcove1178083alcove
alder65421913alde_r
alders74218423alders
aldol61212333aldol_
aldols7109713aldols
aldose7311093aldose
ale36572343a___le
alec66430063a_le_c
alecs76620733a_lecs
alef76340693a_le_f
alefs87319663a_lefs
aleph10311393a_leph
alert54740653a_lert
ales47067103a_le_s
algae65319623a_lgae
algal66518223algal_
alien56425583alie_n
aliened81011743aliened
alienee71013153alienee
aliener71011193aliener
alienly1037503alienly
aliens65619213aliens
alike95523963a_like
aline57243153a_line
alive85722513a_live
alkali10127563alkali
alkane104313323alkane
alkenes114212753alkenes
alkie95520033a_lkie
alkine104916803alkine
alkyl12518043alkyl_
alkyls13465723alkyls
alkyne13436863alkyne
all36148233a_l_l_
allay85620393all_ay
allayed11138063allayed
allayer10148213allayer
allays94313743allays
allegers9378233allegers
allegro844853allegro
allelism1046973allelism
alleluia843373alleluia
allergen9135893allergen
allergy1144503allergy
allheal1044553allheal
allheals1143913allheals
alliable1038433alliable
allied74217153allied
allies63827673allies
allium8311243allium
allod64418383all_od
allods73615083allods
allonge837023allonge
allot54933873all_ot
allots64019173allots
allover1038583allover
allow85420663all_ow
allowed111610083allowed
allows94517683allows
alloy85519973all_oy
alloyed11158033alloyed
alloys94014563alloys
alls46740923a_l_ls
allseed835953allseed
alluded9327093alluded
alludes83610333alludes
allured8299173allured
allurer7348433allurer
allures72913113allures
ally76935643a_l_ly
allylic12155843allylic
alme65832163a_l_me
almeh106214553alme_h
almehs11619493almehs
almes75126543alme_s
almuce10348213almuce
almude9399933almude
aloe45540193a_l_oe
aloes54933673aloe_s
alone55732963a_lone
alpine84417373alpine
alsike1047913alsike
alter54828503alte_r
altered83215733altered
alterer72713993alterer
alters64924223alters
aludel747863aludel_
aludels835303aludels
alula5317093a_lula
alulae6312743alulae
alveoli1043583alveoli
alvine94614583alvine
amble95924643a_mble
amole75724593a_mole
ampere10514413ampere
ample94720303a_mple
ampule10710613ampule
amylene12106883amylene
aneled74719283a_neled
aneles64626293a_neles
angel65019563angel_
angeled93211513angeled
angels74416173angels
angle64528873a_ngle
anile54634463a_nile
ankle95220253a_nkle
anlace82513923anlace
anlage72514233anlage
annexe1337813annexe
anole55330383a_nole
apiece10510083apiece
aplite8316393aplite
appel94615893appel_
appels104312793appels
apple94517673a_pple
arable81821003arable
areae55229743a_reae
arene55329413a_rene
areole61017283areole
arete56031353a_rete
argle65421563a_rgle
argyle1066063argyle
ariel55228973ariel_
ariels65119373ariels
arles56735743arle_s
artel56122743artel_
artels66216233artels
asleep847283asleep
aslope839013aslope
athlete1068083athlete
audile73315303audile
aureole738693aureole
awee76336643a_we_e
awhile1257793awhile
awless939263awless
axel115222073a_xel_
axels126313633a_xels
axile126020513a_xile
axle116424603a__xle
axled135315813axle_d
axles125219473axle_s
axlike17388853axlike
azole145118033a_zole
bailee84526013baile_e
ballade104012563ballade
balled94926893balle_d
baller83825203balle_r
ballers94421013ballers
ballet84733973balle_t
ballets93719513ballets
ballute938543ballute
belle75827833bel_le
bluely113310083bluely
bolete8519613bolete
cadelle1039923cadelle
calicle113111433calicle
callable12310753callable
called94126733calle_d
callees94117783callees
caller85125483calle_r
callers94221963callers
callet84536763calle_t
callets93821703callets
callose9313663callose
calycle14245833calycle
cellule936523cellule
clepe94617383_clepe
college102410443college
dalles74222063dalle_s
dele56843083__dele
delete73620703delete
diallel845683diallel_
ekuele1034383ekuele
faille93414743fail_le
fallal93612693fallal_
fallals103310193fallals
fallen93813373falle_n
faller94621233falle_r
fallers103917993fallers
fallible1355363fallible
falsely1336013falsely
fille84327403fil_le
flee76238793_fle_e
fleece11369903fleece
gabelle10259213gabelle
galeae74717453galeae
galere73716673galere
galilee8312213galile_e
gallate83417123gallate
galled84622863galle_d
gallein8299043gallein
galleon8278713galleon
gallery11468743gallery
gallet73630853galle_t
galleta8399643galleta
galleted1038213galleted
gallets83517403gallets
galley104215453galle_y
galleys11369713galleys
gallfly1433523gallfly
gazelle17236333gazelle
gelee63626983gele_e
glebe85016443_glebe
glede75517833_glede
glee55239063_gle_e
hallal94415563hallal_
haltere103614703haltere
iller54821293ille_r
illest63615723illest
illite63414923illite
illude7327503illude
illume8298223illume
kantele1138253kantele
label75019383label_
labeled102510563labeled
labeler92310183labeler
labels84515683labels
labile8315223labile
ladle66320443_ladle
lall45531313lal_l_
lalled74218753lalle_d
lalls55324133lal_ls
lamely114013223lamely
lanely93914483lanely
lapel73716683lapel_
lapeled10258893lapeled
lapels83712043lapels
laree56036293lare_e
lately93413843lately
lee36068143__le_e
leke85527403__leke
liege65314433_liege
lieve86315473_lieve
lisle53916723_lisle
malleable1376073malleable
malled94626113malle_d
mallees93315973mallees
mallei84414633malle_i
malleoli1054053malleoli
mallet84433053malle_t
mallets93318493mallets
malleus92911313malleus
melee73729103mele_e
mille75029133mil_le
mycele1335853mycele
nacelle938153nacelle
paleae84820293paleae
palely11311933palely
palled94625163palle_d
pallet84232653palle_t
palleted1139873palleted
pallets93919303pallets
pallette1039513pallette
pele65539553__pele
pilule8411123pilule
plebe95014873_plebe
pollee83623273polle_e
ralline73518413ralline
rallye95110163rall_ye
releve95116403releve
rille55728733ril_le
salable91415463salable
sallet63734543salle_t
sallets73719653sallets
selle54428313sel_le
sleeve93411593sleeve
slieve9359273slieve
solely93714213solely
stele55026843_stele
taille63116923tail_le
tallage82712073tallage
taller63721963talle_r
tallest7317093tallest
tallol63612223tallol_
tallols73311363tallols
tele45040873__tele
tulle54019933tul_le
ukelele1142993ukelele
ukulele1142403ukulele
ullage739043ullage
vallate103016563vallate
valley124311603valle_y
valleyed1534013valleyed
valleys13407483valleys
valvelet1445343valvelet
valvule1343663valvule
vilely1239443vilely
walled104021293walle_d
wallet93327093walle_t
wallets103914833wallets
walleyed1534153walleyed
walleyes1435603walleyes
wallie93216803wall_ie
xylene1645793xylene

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.393454684.5
2DLD Change Limit1127163605.09322131.6
3Display Results3603600.1232926.8
 (SQL Overall)1786913605.60931857.9
 
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.