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

209 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
ferulas10311075(None) 
ferula93011171ferula_
ferulae10309601ferulae
ferules103112721ferules
cedulas1058502cedulas
fecula113310052fecula_
feculae12339202feculae
fellas95116962fe_llas
ferals94216642feral_s
ferias95020392fer_ias
ferrules1136162ferrules
ferule93413202ferul_e
feruled11318422feruled
fibulas12228562fibulas
formulas1346302formulas
morulas959712morulas
nebulas957582nebulas
neurulas844832neurulas
torulas759852torulas
verglas1137812verglas
acerolas1048053acerolas
aerials74017553aerials
aerugos834923aerugos
areolas71013863areolas
begulfs1333753begulfs
belugas1035903belugas
bermudas1342973bermudas
berthas12398763berthas
beryls11107883beryl_s
canulas9312853canulas
cedula977643cedula_
cereals9313173cereals
cerias83321983cer_ias
cerulean1053773cerulean
ceruleans1192923ceruleans
ceruses93716233ceruses
cervelas1344673cervelas
cesuras958693cesuras
copulas113811563copulas
dermas94116813der_mas
doulas75114993_doulas
equals1538693_equals
eras45441503_er__as
ericas8315463_ericas
eructs83610793_eructs
erugos7347343_erugos
erupts8348903_erupts
exults13257633_exults
fabular12288693fabular
facula112912233facula_
faculae123210353faculae
facular122810443facular
famulus1235043famulus
farfals13268503farfals
farinas103215243farinas
farles96025783far_les
farls85731113far_l_s
faulds10438963f_aulds
faults94513553f_aults
faunas94013633f_aunas
favelas1337023favelas
fecials123510333fecials
fedoras1137923fedoras
feels85223043fe_el_s
feijoas1742323feijoas
fella84918653fe_lla_
fellah124910773fe_llah
fellahs13428393fe_llahs
fells85327383fe__lls
felts85324543fe__lts
feluccas1542213feluccas
females12310663females
femurs1136713femu_rs
feral85424653fer__al
ferbam1339003fer_bam
ferbams1435743ferbams
feres86038183fer__es
feria85922713fer_ia_
feriae95618603fer_iae
ferial94621253fer_ial
ferlie92814053fer_lie
ferlies103216693ferlies
ferly115517353fer_l_y
fermatas13246223fermatas
fermis114313503fer_mis
fernless1136063fernless
ferns85220083fer__ns
ferrels10248623ferrels
ferrets103111393ferrets
ferries103521083ferries
ferrous1049803ferrous
ferrule1035863ferrul_e
ferruled1263923ferruled
ferrums1265983ferrums
feruling1258873feruling
fervors1336233fervors
fetas85624403fe__tas
fetials103711743fetials
fettles103912733fettles
fetus85816543fetu__s
fetuses10310243fetuses
feuar8310243fe_u_ar
feuars938653fe_uars
feudal1037683fe_udal
feuds95914883fe_u_ds
feus75830753fe_u__s
fibula11258053fibula_
fibulae12237013fibulae
fibular12267973fibular
fistulas1155403fistulas
flautas1036153flautas
formals123312893formals
formula1246293formula_
formulae1345983formulae
forums114611843foru_ms
fouls87221433f_oul_s
fracas11311993f_racas
frenula1045623frenula_
frenular1144633frenular
frills94414223f_rills
frugal1036393f_rugal
frugs96114283f_ru_gs
fruits94512493f_ruits
frumps13479783f_rumps
fulls84623523f__ulls
fumulus1234443fumulus
furcula1245793furcula_
furculae1345063furculae
furcular1345703furcular
furls85322053fur_l_s
gerunds935183gerunds
heralds1137713heralds
herbals122710603herbals
hercules1337633hercules
herls85226433her_l_s
hernias10310773hernias
hulas84920883__hulas
jerboas1636163jerboas
kerrias11289513kerrias
korunas1135443korunas
lehuas935943lehu_as
ligulas8329173ligulas
maculas113114023maculas
medullas1144513medullas
medusas1036213medusas
merles85322763mer_les
merls77423903mer_l_s
mezuzas1743233mezuzas
morula8710473morula_
morulae958963morulae
morular978223morular
nebula857333nebula_
nebulae955493nebulae
nebular956483nebular
nerolis71012773nerolis
nerols6914883nerol_s
nervules1145013nervules
neurula744373neurula_
neurulae843383neurulae
neurular844003neurular
paruras9310533paruras
penults937123penults
pergolas1158233pergolas
perillas10310823perillas
perils84121853peril_s
perukes133210113perukes
perusal939193perusal
perusals1047143perusals
peruses94018163peruses
pyrolas1239863pyrolas
radulas839583radulas
ranulas7311773ranulas
regular838423regular
regulars936253regulars
regulus836523regulus
remudas1035833remudas
rerolls739943rerolls
reruns66413743reru_ns
results739833results
rules55234253__rules
secular92211533secular
seculars10219393seculars
serials73919743serials
serosas7312663serosas
serumal938783serumal
serums83916303seru_ms
servals103410743servals
sevrugas1242153sevrugas
spirulas10207203spirulas
strumas9419833strumas
teguas768013tegu_as
tegular836603tegular
tequilas1743283tequilas
terbias9310743terbias
terras63516973ter_ras
teslas64212173te_slas
torula6610393torula_
torulae758553torulae
trulls64110283_trulls
uvulas946523_uvulas
venular1037683venular
venules104011483venules
verbals121910743verbals
veritas103012753veritas
verrucas1343923verrucas
xerus12313333xeru__s
xeruses143010753xeruses
yerbas11119293yer_bas
zonulas1637023zonulas

Search took 9 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.830215290.4
2DLD Change Limit1340272097.59317651.4
3Display Results2092090.0762750.0
 (SQL Overall)1786912098.49921024.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.