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

176 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
fabular1228869(None) 
facular122810441facular
fibular12267971fibular
pabular11259471pabular
tabular9279761tabular
alular6311352_alular
canular9310322canular
fabler116115812fab_ler
fabulate1339202fabulate
fabulator1445392fabulator
facula112912232facula_
faculae123210352faculae
fibula11258052fibula_
fibulae12237012fibulae
fibulas12228562fibulas
hamular1236972hamular
lobular936662lobular
macular113011942macular
nebular956482nebular
papular11299762papular
radular837832radular
ranular739432ranular
tubular9267472tubular
abler75624313_ab_ler
abulia83512503_abulia
abulias93210693_abulias
abulic106411423_abulic
abuser85413683_abuser
alar46340073_a__lar
alula5317093_alula_
alulae6312743_alulae
angular838533angular
annular737693annular
ashlar9338193_ashlar
aurar54420253_a_urar
babbler104012823babbler
babul96317713babul__
babuls105413643babul_s
bacula103112683bacula_
basilar937303basilar
bolar75123473__bolar
bulbar1039583__bulbar
cabala103516913cabala_
cabalas113516003cabalas
cabler104519173cab_ler
cannular1046283cannular
canula8312963canula_
canulae9311183canulae
canulas9312853canulas
capsular1245403capsular
copular113810603copular
cupular11317623cupular
dabbler124012153dabbler
fabber134814113fab_ber
fable105824753fab_l_e
fabled124216383fab_led
fablers124812613fab_lers
fables114921673fab_les
fabliau1244903fabliau
fabulated1546323fabulated
fabulates1447733fabulates
fabulators1544693fabulators
fabulist1347673fabulist
fabulous1344853fabulous
faculty1535573faculty
falbala1235873falbala_
falbalas1345473falbalas
fallal93612693fa_llal
faller94621233fa_ller
familiar1365953familiar
famuli1136763famul_i
famulus1235043famulus
faquir1834313faqu_ir
faucal11339963fa_ucal
fauld95214493fa_ul_d
faulds10438963fa_ulds
fault85428313fa_ul_t
faults94513553fa_ults
faulty12429363fa_ulty
fauna84816513fa_una_
faunae95210373fa_unae
faunal94711593fa_unal
faunas94013633fa_unas
favela1237033favela_
favelas1337023favelas
fecula113310053fecula_
feculae12339203feculae
ferula93011173ferula_
ferulae10309603ferulae
ferulas103110753ferulas
feuar8310243f_eu_ar
filar84819293f__ilar
fistular1144253fistular
foulard11257283f_oulard
fouler93614903f_ouler
frenular1144633frenular
fubar1039923f__ubar
fulmar1137253f__ulmar
furcular1345703furcular
gabbler124013303gabbler
globular1143383globular
granular946893granular
gular6314833__gular
hauler95015123ha_uler
insular7138703insular
jaguar1435283jagu_ar
jocular1637303jocular
jugular1534513jugular
kabala124011553kabala_
kabalas133911063kabalas
kabar114815553kab__ar
labeler92310183labeler
lacunar9136293lacunar
ligular8348533ligular
locular938953locular
lunular736013lunular
macula103013673macula_
maculae113412863maculae
maculas113114023maculas
malar76424443ma__lar
mauler84416713ma_uler
modular1087363modular
morular978223morular
mutular936643mutular
nebula857333nebula_
nebulae955493nebulae
nebulas957583nebulas
nodular876703nodular
ocular8610133_ocular
oracular1047533oracular
oscular937933oscular
ovular946833_ovular
pabulum1344473pabulum
papula103011113papula_
papulae11249353papulae
piacular1246573piacular
pilular938203pilular
planular1044753planular
popular11319563popular
qabala17399193qabala_
qabalah21285033qabalah
qabalas18289503qabalas
rabbler113514093rabbler
radula749313radula_
radulae837963radulae
radulas839583radulas
ranula6311813ranula_
ranulas7311773ranulas
regular838423regular
saccular1246893saccular
scapular1245373scapular
secular92211533secular
simular938673simular
spatular1044653spatular
subalar9118073subalar
tabla73318363tab_la_
tablas83716163tab_las
tabularly1443513tabularly
tabulate10310893tabulate
tabulator1145923tabulator
tabuli839363tabul_i
tabulis938833tabulis
talar56225383ta__lar
tegular836603tegular
titular737523titular
tumular9236543tumular
undular837123undular
ungular836773ungular
uvular955563_uvular
vacuolar1353483vacuolar
valvular1443463valvular
vascular1346293vascular
venular1037683venular
vocabular1652163vocabular
wabbler143511923wabbler
zonular1656493zonular

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 Filter1786911340270.410435831.7
2DLD Change Limit1340271766.06022116.7
3Display Results1761760.0632793.7
 (SQL Overall)1786911766.53327352.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.