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

293 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
ferula9301117(None) 
fecula113310051fecula
ferulae10309601ferulae
ferulas103110751ferulas
ferule93413201ferule
cedula977642cedula
facula112912232facula
feculae12339202feculae
fella84918652fe_lla
feral85424652feral_
ferals94216642ferals
feria85922712fer_ia
ferial94621252ferial
ferly115517352fer_ly
ferrule1035862ferrule
feruled11318412feruled
ferules103112722ferules
fibula11258052fibula
formula1246292formula
frenula1045622frenula
furcula1245792furcula
morula8710472morula
nebula857332nebula
neurula744372neurula
torula6610392torula
acerola947823acerola
aerial64625713aerial
aerily93017013aerily
aerugo735803aerugo
alula5317093_alula
areola6813673areola
bacula103112673bacula
begulf1238903begulf
beluga936233beluga
bertha11429173bertha
beryl101211673beryl_
beryls11107883beryls
canula8312963canula
cedulas1058503cedulas
cella75420313ce_lla
cercal10314123cercal
cereal8315833cereal
ceria75125353cer_ia
cerulean1053773cerulean
ceruse83914523ceruse
cesura838763cesura
copula102812043copula
crura7312583_crura
cupula10328433cupula
curule83614123curule
derma84918513der_ma
dermal93614343dermal
doula65717773_doula
eerily92913563eerily
equal1449823_equal
era35741503_er__a
erica7316543_erica
eruct74022353_eruct
erugo6369853_erugo
erupt74220063_erupt
exult122814123_exult
fabular12288693fabular
faculae123210353faculae
facular122810443facular
famuli1136763famuli
farfal123410183farfal
farina94618233farina
farl76338553far_l_
farle86929243far_le
farls85731113far_ls
fauld95214493f_auld
fault85428313f_ault
fauna84816513f_auna
favela1237033favela
feal713940423fe_al_
fearful1345593fearful_
featly123711753featly
febrile1237153febrile
fecal105119213fecal_
fecial114714623fecial
feckly18335963feckly
fecund1235433fecund
fedora1038593fedora
feeble1138253feeble
feebly1436653feebly
feel75233843fe_el_
feels85223043fe_els
feijoa1642223feijoa
fell76833073fe__ll
fellah124910773fe_llah
fellas95116963fe_llas
fells85327383fe_lls
felly114922803fe_lly
felt75146933fe__lt
felucca1442123felucca
female11310553female
femora1149583femora
femur1038683femu_r
femurs1136713femurs
fer66646123fer___
ferbam1339003ferbam
fere76342233fer__e
feres86038183fer_es
feriae95618603feriae
ferias95020393ferias
ferine96422583ferine
ferity122813343ferity
ferlie92814053ferlie
fermata12278143fermata
fermi103914163fer_mi
fermis114313503fermis
fern76129323fer__n
ferns85220083fer_ns
ferny115816183fer_ny
ferrel92810203ferrel
ferrels10248623ferrels
ferret93021173ferret
ferric1139993ferric
ferruled1263923ferruled
ferrules1136163ferrules
ferrum1147453ferrum
ferrums1265983ferrums
ferry116020803fer_ry
fertile10311733fertile
feruling1258873feruling
fervid1337513fervid
fervor1235643fervor
festal94213563festal
feta76528903fe__ta
fetal85623373fetal_
fetial95716193fetial
fettle93713123fettle
fetus85816543fetu_s
feu67843663fe_u__
feuar8310243fe_uar
feud86523023fe_u_d
feudal1037683fe_udal
feuds95914883fe_uds
feued94715663fe_ued
feus75830753fe_u_s
feyly14429513fe_yly
fibulae12237013fibulae
fibular12267973fibular
fibulas12228563fibulas
fierily1339023fierily
fila74729133f__ila
firmly1436663firmly
fistula1045503fistula
flauta937823flauta
fora75937393for__a
formal113215203formal
formulae1345983formulae
formulas1346303formulas
forum108318763foru_m
forums114611843forums
foul77027583f_oul_
fouls87221433f_ouls
freely12310953freely
frena85915273f_rena
frenular1144633frenular
frill84917563f_rill
frug86517103f_ru_g
frugal1036393f_rugal
frugs96114283f_rugs
fruit85122223f_ruit
frump126912563f_rump
frusta937453f_rusta
full75229153f__ull
fumuli1135263fumuli
furculae1345063furculae
furcular1345703furcular
furl77030883fur_l_
furls85322053fur_ls
fusuma1134503fusuma
genua64614153genu_a
gerund836163gerund
herald10311343herald
herbal112513493herbal
herl75834553her_l_
herls85226433her_ls
herma105318883her_ma
hernia9312293hernia
hula74923753__hula
jejuna1243243jejuna
jerboa1535633jerboa
jugula1434983jugula
kerria10339913kerria
koruna1035483koruna
lehua837953lehu_a
ligula7359673ligula
lunula636173lunula
macula103013673macula
medulla1044713medulla
medusa936293medusa
merely111312583merely
merl65830973mer_l_
merle75824373mer_le
merls77423903mer_ls
mezuza1643533mezuza
morulae958963morulae
morular978223morular
morulas959713morulas
nebulae955493nebulae
nebular956483nebular
nebulas957583nebulas
nebule848753nebule
nebuly1135793nebuly
nerol51017813nerol_
neroli61111153neroli
nerols6914883nerols
nervule1044943nervule
neural6311993neural
neurulae843383neurulae
neurular844003neurular
neurulas844833neurulas
opercula1244993opercula
oscula837293oscula
papula103011113papula
parura8310583parura
peculia1147133peculia
penult8314653penult
pepla9312863pe_pla
perea75026443per_ea
pereia85217983pereia
pergola1067623pergola
peril75425953peril_
perilla9311223perilla
perils84121853perils
pertly115312543pertly
peruke123210393peruke
perusal939193perusal
peruse84016843peruse
pruta7314243_pruta
pteryla1243303pteryla
pula65129373__pula
pyrola1139003pyrola
radula749313radula
ranula6311813ranula
regular838423regular
reguli738143reguli
remuda936823remuda
reroll6412683reroll
rerun58722153reru_n
reruns66413743reruns
result6318223result
ruga56121233__ruga
rule49938423__rule
ruly76323143__ruly
secular92211533secular
sequela1663993sequela
sera46141393ser__a
seral56336383seral_
serial64625863serial
serosa6313023serosa
serum75223473seru_m
serumal938783serumal
serums83916303serums
serval93913413serval
sevruga1142223sevruga
sexual1338413sexual
specula11187413specula
spirula9257703spirula
struma84313273struma
tegua6109563tegu_a
tegular836603tegular
tela45532973te__la
tequila1644583tequila
terbia8311153terbia
terga63315643ter_ga
tergal72912833tergal
termly1138433termly
terra54419663ter_ra
tesla55612603te_sla
torulae758553torulae
torulas759853torulas
trull54012673_trull
truly84111553_truly
ungula737603ungula
unruly938083unruly
uvula845153_uvula
vela75725543ve__la
venular1037683venular
venule94411763venule
vera76828843ver__a
verbal112513663verbal
verglas1137813verglas
verily122616053verily
vernal93514213vernal
verruca1243713verruca
versal93013753versal
xerus12313333xeru_s
yerba101010763yer_ba
zonula1537223zonula

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.1401276364.3
2DLD Change Limit1127162936.17018268.4
3Display Results2932930.0933150.5
 (SQL Overall)1786912936.40327907.4
 
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.